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...