From dates to working hours formula with General Caster App

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

1 Like

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.