Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shift Differential Formula
I am looking for a formula to tabulate a formula for shift differential
between the hours of 17:00 and 7:00. If you had worked this shift you would have 14 hours of shift differential. If you worked 9:00 - 19:00 you would have 2 hours of shift differential. Column D7 is the start time and E7 is the end time, with the shift diff tabulating in K7. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shift Differential Formula
On Dec 17, 12:40*pm, LVSU wrote:
I am looking for a formula to tabulate a formula for shift differential between the hours of 17:00 and 7:00. If you had worked this shift you would have 14 hours of shift differential. If you worked 9:00 - 19:00 you would have 2 hours of shift differential. Column D7 is the start time and E7 is the end time, with the shift diff tabulating in K7. Thanks. for instance the start time woudl be in Column A. If you type in the times into a cell and format the cell as numbers, this will tell you how Excel views these times. Then just a simple If statement with an Or in there and there you go. So this eads that if the start time is greater then .71 or less then or = to 1 then it will activate or if it is between .29 and .001, then it will activate, if not then it will be 0. |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shift Differential TimeSheet Formulas | Excel Worksheet Functions | |||
FORMULA THAT CALCULATES HH:MM ON THIRD SHIFT(BETWEEN TWO DAYS) | Excel Discussion (Misc queries) | |||
payroll formula when shift is 3pm to 1 am | Excel Discussion (Misc queries) | |||
Time Differential Error??? | Excel Worksheet Functions | |||
Formula to determine shift | Excel Worksheet Functions |