Here’s the formula.
TIMEVALUE({item's Clock-out}) - TIMEVALUE({item's Clock-in})
Here’s the formula.
TIMEVALUE({item's Clock-out}) - TIMEVALUE({item's Clock-in})
I had to add HOUR(TIMEVALUE({item’s Clock-out}) - TIMEVALUE({item’s Clock-in})
It only shows up as a solid number but I would need it to show with decimal points. Guys are going to be paid from this. So 7 hours and 30 minutes would show as 7.5
@rob is that something you could help with?
My previous suggestion should already calculate the difference with decimals.
Just multiply the difference by 24.
(TIMEVALUE({item's Clock-out}) - TIMEVALUE({item's Clock-in})) * 24
Roberto, could you give a hand with the hours difference between two dates? I’ve been trying this with quite a few variables variations but keep receiving an error:
HOUR(TIMEVALUE({Activity’s Date Ends})-TIMEVALUE({Activity’s NEXT}),“HH:MM"SS”)
Thank you.