Hello all,
I have columns on a spreadsheet for times like the following:
10:00 AM 2:00 PM 2:30 PM 1:00 AM
Column 1 is TIME IN
Column 2 in BREAK TIME OUT
Column 3 in BREAK TIME BACK IN
Column 4 is TIME OUT
I need a formula that will tell me how many of these hours in the timecard record happened 8AM until 3PM; 3PM until 7PM; and 7PM until 4AM
Anyone? This has been real tough for me, especially since the final time out is technically the next day...
Bookmarks