F, G, H are the forumla cells listed below.
I have mine set up as above. Day being mon, tues, wed....
then in col F i have formula:
=ROUND((((E3-B3) - ( D3-C3))*24)/0.25,0)*0.25
Then in F10 I do a sum of all the hours in F.
In G10 I calculate the regular hours by using:
In H10 I calculate the Overtime Hours by using:
the format on the cells where time is entered is this time format: 4/28/2009 12:30:00 PM
Adding the date as i have above should solve the problem with shifts going past midnight.