Timesheet Formula Problem

[Bridie]

I am trying to set up a timesheet to cover staff working 24 hrs. Day an
night hours are paid at a different rate (and staff members all hav
different rate of pay). The day hours start at 7.00 and end at 19.00
Night hours are in between. It is the calculation of the hours I a
having trouble with.
The spreadsheet is laid out as follows:
Cell R4 is Start Time S4 is Finish Time T4 is Day Hours U4 is Nigh
Hours. I have entered hours for the first two staff in the followin
cells:
R5 contains 20.00 and S5 contains 9.00
R6 contains 6.00 and S6 contains 18.00.
I have tried numerous formula but none of them work correctly. I woul
be very grateful for any assistance

 

[NickMinUK]

I have spent hours trying to get to grips with time formulas for tim
sheets and eventually cracked it. If you send your example I will hav
a look. (e-mail address removed)

 

[JE McGimpsey]

Take a look at

http://cpearson.com/excel/datetime.htm#AddingTimes

and perhaps

http://cpearson.com/excel/overtime.htm

 

[NickMinUK]

Attached solution, but it does not cope with every variabl

Attachment filename: time sheet solution.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=57986