Expression to calculate hours worked based on timestamps?

I’d like to add a virtual column to calculate hours worked based on the check in timestamp and check out timestamp. I thought I’ve seen similar expressions posted in the community but couldn’t find any. Help is appreciated. Thanks

check out TOTALHOURS()

TOTALHOURS([Finish Timestamp] - [Start Timestamp])


Why does it show as a negative? The checked in time was 3/7 at 9:54:01

I need to display as 41 minutes, or 8 hours (if that had been the case).

I fixed the negative issue - had the expression in wrong order.


My problem as well many times. :crazy_face:

1 Like