Duration Type returning Decimal

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?



What is the expression that calculates the value?

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

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

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

1 Like

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.

1 Like

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

1 Like