Another Time Calculation Question

[Ana]

I have a question regarding time calculation minus breaks. My bos
wants a spread sheet where he can type in the time in then time out fo
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,

An

 

[Guest]

Time is easier when you remember how many hours are in a day. in cell A1, enter your end time. In A2, your start time. Make sure that these are in time format. In A3, enter in =A1-A2, then format to number, 2 decimal places. In A4, enter in =A3*24 (for hours in a day)

For example (presuming formulas are entered, these are the answers
12:00 P
8:00 A
0.1
4.0

Hope this helps

Art

 

[Tom Ogilvy]

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

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