Tracking Time Differance

**BigEye64** · 11-20-2008, 07:16 AM

Hi

I am trying to track 2 processes time difference I need to add a variable amount of Minutes to a Time in 24 hour format so as I can track the difference in times. Its driving me nuts could some kind sole show me how to add Minutes to the Time as shown.

**oldchippy** · 11-20-2008, 07:39 AM

Hi,

Not sure I understand what you are doing here, can you explain a little more and the expected result

**BigEye64** · 11-20-2008, 08:39 AM

I would like to enter a time in Minutes in cells B2 and D2 for two different Continuous Casting machines I work on. The Time in minutes represents the total time it takes to empty a ladle of steel. I need to pace the two machines so as there is a gap of 35 minutes between ladle openings to facilitate having both machines running at the same time. This is a easy thing to do but when things go wrong and one machine is running slower than it should I need to be able the enter a time in 24 Hour time in Cell B5 and have it add the time that has been entered in minutes in Cell B2 displaying the new time in in B7 then the next new time in B9 and so on. I need to do the same with the information in D column. From this I need to work the difference between times so as I can track the differences.

**oldchippy** · 11-20-2008, 12:10 PM

Hi,

Does this work for you?

B5=(B2+35)/1440

D4=(D2+35)/1440

both formatted as hh:mm

**BigEye64** · 11-20-2008, 01:48 PM

Originally Posted by oldchippy

Hi,

Does this work for you?

B5=(B2+35)/1440

D4=(D2+35)/1440

both formatted as hh:mm

Alas no I need to enter a time in B5 say 12:30 and a variable in Minutes say 70 minutes in B2 and have it calculate the next time for (B7) 13:40 (B9) 14:50 and so on.