See example/downloadable workbook at John Walkenbach's site:

http://j-walk.com/ss/excel/files/timesht.htm

--
Regards,
Tom Ogilvy


"Ana " wrote in message
...
I have a question regarding time calculation minus breaks. My boss
wants a spread sheet where he can type in the time in then time out for
lunch, then time back in and time out for the day.

I know it's a bit confusing but I'd appreciate any help on this one.

Thanks so much,

Ana


---
Message posted from http://www.ExcelForum.com/