Hour format

[#1]

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

[Clever_Anjos · Accepted solution]

Time(Frac(youdatefield)) // returns only the hours between 24 period

or

Interval(yourdatefield) // returns the interval: 33:06 for example