Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I got a simple problem, i want to know a way to be able to represent hours without needing to do days.
For example,
im using
Date(0.5046840439363,'hh:mm') and it returns 12:06. as 12 hours and 6 minutes.
The problem is when i do Date(1.5230717969886,'hh:mm'), it kinda only takes the decimal parte and returns 12:33, i was looking somehitng more like 36:33 hours, insted of spliting it with days.
Any ideas?,
thanks
Time(Frac(youdatefield)) // returns only the hours between 24 period
or
Interval(yourdatefield) // returns the interval: 33:06 for example
Time(Frac(youdatefield)) // returns only the hours between 24 period
or
Interval(yourdatefield) // returns the interval: 33:06 for example