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?

image

thanks

What is the expression that calculates the value?

Hi Steve,
this:
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