Hi

This might help you in the right direction!
http://www.cpearson.com/excel/overtime.htm

--
Andy.


"Fay" wrote in message
...
I want to create a spread sheet that will extract time blocks. I have a
manager that is having trouble with time cards. I want her to be able to
enter the hours worked for example 1900 to 0730. I need Excel to figure
that
1900 to 2300 is four hours on the evening shift, 2300 to 0700 is 8 hours
on
the night shift and 0700 to 0730 is one half hour of overtime on the day
shift. I will put each shift in a separate column. So how to I formulate
the
basic question? Thank you. Hopefully I am clear enough, if not please let
me
know.

Fay