Thanks Larry, but I should have mentioned that all our managers want to see
is the start and end times for each day. We have set lunch periods, but not
at specific times during the day. Thanks again though for your quick
response!!!

Paul

"keithl816" wrote:


Hi Paul,

If you have the begin time in a1, lunch start in b1, lunch end in c1,
and end of day in d1.

Something like this should work in e1

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

Make sure to use this type of time format 15:30 instead of 3:30

Hope this helps

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=491660