G
Guest
I am trying to create a spreadsheet that will calculate time cards less a
lunch period. I cannot seem to get it to calculate the reduction of the
lunch period properly. Columns A,B & C would be input. Can anyone help?
Column A Column B Column C Column D
Start time End time Lunch Total Hours
7:32 4:00 :30 ?
7:30 4:15 :30 ?
7:35 4:30 :35 ?
8:00 4:30 0 ?
7:30 4:02 :30 ?
Total Hours ?
lunch period. I cannot seem to get it to calculate the reduction of the
lunch period properly. Columns A,B & C would be input. Can anyone help?
Column A Column B Column C Column D
Start time End time Lunch Total Hours
7:32 4:00 :30 ?
7:30 4:15 :30 ?
7:35 4:30 :35 ?
8:00 4:30 0 ?
7:30 4:02 :30 ?
Total Hours ?