Timesheet Formula Problem

I am trying to set up a timesheet to cover staff working 24 hrs. Day and
night hours are paid at a different rate (and staff members all have
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 am
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 Night
Hours. I have entered hours for the first two staff in the following
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 would
be very grateful for any assistance.


---
Message posted from http://www.ExcelForum.com/

I have spent hours trying to get to grips with time formulas for time
sheets and eventually cracked it. If you send your example I will have
a look.


---
Message posted from http://www.ExcelForum.com/

Take a look at

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

and perhaps

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




In article ,
Bridie wrote:

I am trying to set up a timesheet to cover staff working 24 hrs. Day and
night hours are paid at a different rate (and staff members all have
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 am
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 Night
Hours. I have entered hours for the first two staff in the following
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 would
be very grateful for any assistance.

Attached solution, but it does not cope with every variable

Attachment filename: time sheet solution.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=579860
---
Message posted from http://www.ExcelForum.com/