http://www.cpearson.com/excel/overtime.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Flash" wrote in message
...
Can anyone help?
I am trying to produce and overtime sheet which covers an entire month
period.
The columns consist of date, day of week, start and finish times and total
hours worked. There is also a cell that contains the daily contracted
hours
which is used to help calculate the overtime hours worked (if any) for
that
day. The calculations works fine for the week days but on the Saturday
and
Sunday (non working days) it treats the day as a normal working day and
produces overtiem hours for a Saturday as if it was a normal week day.
Does anybody know what formula can be entered in the cells that will sum
up
the total hours worked for any day, but in addition differentiate between
a
normal week day and a Saturday and Sunday, then return the full overtime
hours for that day.

Hope you can help