Your prompt response is highly appreciated,it will be a great help to me at
my office.
Its a wonderful forum.
Thanks & Regards
"Mike H" wrote:
> 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
> "SAB2000" wrote:
> > 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
sab2000
| Fri, 23 May 2008 18:21:00 GMT |