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
|
|||
|
|||
Calculating Time
Hi
I'm trying to do a basic workshift for adding up my timesheets for work. I work 07:00 to 14:00 on the morning shift, 14:00 to 21:00 on the afternoon shift and 21:00 to 07:00 on nights. Then I have to add 20% for the shift premium. In column A I've put the start time, Column B the finish time, Column C the total and Column D the extra 20%. My problem lies when I take column A from Column B, It won't calculate night shift because the first figure is greater than the second TIA Steve |
#2
|
|||
|
|||
Calculating Time
Steve, take a look at Chip Pearson's discussion of date and time arithmetic
at http://www.cpearson.com/excel/datearith.htm, and scroll down to "Time Intervals." -- DDM "DDM's Microsoft Office Tips and Tricks" www.ddmcomputing.com "Steve" wrote in message ... Hi I'm trying to do a basic workshift for adding up my timesheets for work. I work 07:00 to 14:00 on the morning shift, 14:00 to 21:00 on the afternoon shift and 21:00 to 07:00 on nights. Then I have to add 20% for the shift premium. In column A I've put the start time, Column B the finish time, Column C the total and Column D the extra 20%. My problem lies when I take column A from Column B, It won't calculate night shift because the first figure is greater than the second TIA Steve |
Thread Tools | |
Display Modes | |
|
|