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
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.
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.
thanks both. i have to comb through the duration total hours sample and see my mistakes.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |