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
Try the TOTALHOURS() function:
TOTALHOURS([Duration])
got this error
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"))
Or just [time] - “00:00:00”
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |