Duration Type returning Decimal

[reggieneo]

Hi All,
I have a start and end DateTime columns and supposed to calculate the duration.

but the result is giving me a decimal type and so is of course giving an error of invalid type.

what is the solution here please?

thanks

[Steve]

What is the expression that calculates the value?

[reggieneo]

Hi Steve,
this:
IF(ISBLANK([Time Out]), “”,TOTALHOURS([Duration]))

[Duration] is a VC.
[Time Out]-[Time In]

[Steve]

TOTALHOURS() gives a Decimal value, not a Duration value.

help.appsheet.com

TOTALHOURS()

Count of hours in Duration

[ycr]

If the column type is duration, then the output of formula needs to be duration, if you want to output Total Hours, which is a number, the column type should be decimal or number.

[reggieneo]

thanks both. i have to comb through the duration total hours sample and see my mistakes.