Timecard calculations

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

Does anyone know how to work out this

Time in Time out Time off
07:30 15:30 30 Min

Total time worked
7.5hrs

so how do i work it out to display it automatically???
=(time out-time in)-time off
can't work out a good way of doing it keeps trying to
tell me that 30 minutes is 12:00:00AM
can get it to tell me that there is 8 hours difference
but no further.
please email me at troyis at ihug dot com dot au
 
Hi

You have to format TimeOff as Custom "h:mm" and enter it as 0:30, or you
have to use the formula
=(TimeOut-TimeIn )-TimeOff/(24*60)
and format the result also as "h:mm", which displays for you the answer as
7:30
Or you use the formula
=((TimeOut-TimeIn )-TimeOff)*24
or
=((TimeOut-TimeIn )-TimeOff/(24*60))*24
and format the result as number - to get the same answer as 7.5

And there is something, you have to consider too. Formulas above will fail,
when time intervall expands over midnight. To correct this, use

=(TimeOut-TimeIn +(TimeOut<TimeIn))-TimeOff)
or
I think you can continue yourself now.
 
Back
Top