If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Timesheet Formula Problem
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/ |
#3
|
|||
|
|||
Timesheet Formula Problem
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. |
#4
|
|||
|
|||
Timesheet Formula Problem
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/ |
Thread Tools | |
Display Modes | |
|
|