Another Time Calculation Question

A

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
 
A

Art

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
 
Top