Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate finishing time if night shift aren't working
I have a spread sheet used for production planning which predicts the finsh time of a job depending on its duration. This works fine but I now have the problem that production is no longer 24 hours so if a 12 hour job starts at 15:00, no work will be done between 21:00 and 06:00 (9 hours) so it will finish at 12:00 noon on the following day.
Is there a formula that will add 9 hours to the duration if the calculated finish time falls during the night shift? Thanks in anticipation Martin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate finishing time if night shift aren't working
If your start time is in A2, duration in B2, night shift start time in C$2, night shift finish time in D$2:
Finish time would be =A2+B2+IF(A2+B2C$2,MOD(D$2-C$2,1)) -- David Biddulph "Martin B" wrote in message ... I have a spread sheet used for production planning which predicts the finsh time of a job depending on its duration. This works fine but I now have the problem that production is no longer 24 hours so if a 12 hour job starts at 15:00, no work will be done between 21:00 and 06:00 (9 hours) so it will finish at 12:00 noon on the following day. Is there a formula that will add 9 hours to the duration if the calculated finish time falls during the night shift? Thanks in anticipation Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Total hours worked during workdays within given shift time. | Excel Discussion (Misc queries) | |||
Adding a decimal hours to a starting time to give a finishing tim | Excel Discussion (Misc queries) | |||
Calculate working hours from a start and finish time over several | Excel Worksheet Functions | |||
Working night and day..... Timesheet | Excel Worksheet Functions | |||
How do I write an Excel formula to calculate my working time? | Excel Worksheet Functions |