Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formula
I am using a spreedsheet that automadicly calculates the time it takes to
complete several task. On a separate work sheet I have entered in the step along with the amount of time to perform each step to come up with the total time. If we start at 7:00pm on 7/10/07 it list when the parts will be at the next step and then the subsequent steps. So if we go through 7 steps we will finish at 2:30pm the next day. My problem is that the formula was oringinally written for a 16 hour work day so after mid-night it will not start tracking time until 8:00am. Attached is the formula:=IF(A21="","",IF(AND((MOD(D20,1)+(VLOOKUP( A21,'WORK STEPS'!D$2:E$39,2,TRUE))0.041666),MOD(D20,1)<0.33 3333),IF(WEEKDAY(D20,1)=6,(ROUNDDOWN(D20,0)+2.3333 33+VLOOKUP(A21,'WORK STEPS'!D$2:E$39,2,TRUE)),(ROUNDDOWN(D20,0)+0.33333 3+VLOOKUP(A21,'WORK STEPS'!D$2:E$39,2,TRUE))),D20+VLOOKUP(A21,'WORK STEPS'!D$2:E$39,2,TRUE))) Can someone help me change this to 24 hours? Thanks Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Time / Formula to look at time difference | Excel Worksheet Functions |