duration to hours

[comgen_technolo]

00:00:00 HH:MM:SS Example 00:30:00 = 30min I need to Change this data on Appsheet to Decimal 00:30:00 = 0.5Hour 01:30:00 = 1.5Hour

Any ideas? @graham_howe

[James_Burns]

Try the TOTALHOURS() function:

TOTALHOURS([Duration])

https://help.appsheet.com/en/articles/3543771-totalhours

[comgen_technolo]

got this error

[James_Burns]

Are you trying to convert a time of day into a decimal or a duration?
TOTALHOURS works against durations. If you’re using a time of day try:

TOTALHOURS([time]-TIME(“000:00:00”))

[Joseph_Seddik]

Or just [time] - “00:00:00”