Adding time with different dates

[Guest]

Hi

I have to calculate the overtime of workers. For some employees the time is
different than others but all start their work in the afternoon till next day
morning, I need to subtract 8 normall working hours from the total time daily
to prepare overtime. Employees dont punch their cards at the same time every
day, Please help me to make a formula to calculate the over time for the
whole month.

Regards

 

[Guest]

With the start time in A1 this formila calculate total hours worked:-

=(B1-A1+(B1<A1))*24

Overtime is calcculated with this formula

=((B1-A1+(B1<A1))*24)-8

Drage down for each day in the month and total the answer.

Mike

 

[Guest]

Your prompt response is highly appreciated,it will be a great help to me at
my office.
Its a wonderful forum.
Thanks & Regards