Use of Time when cycling machines

  • Thread starter Thread starter JRS
  • Start date Start date
J

JRS

I need to build a machine cycle time (with idle time). I
can make it work, but the math concerns me. Rather than
go into "how" I did it, I'd like to hear alteranives
please. Here is the scenerio -

1 machine -
Cyle time = 6 minutes, 15 seconds
Idle time = 15 seconds

The format of the cells is mm:ss

I want to determine the number of cycles in 1 hour. Add
the two cells together and divide by 3600?
Now to complicate matters, the cycle and idle time have a
toggle (up/down radio button) that runs from a min = 0,
max = 3599, increments = 1. so the format of those cells
are 'general' numbers. Hence (in my view) a general
number of 360 = 360 seconds, correct?

any help appreciated.
 
Not entirely sure what the question is here but it may help if I explain how dates and time work in exce

A date / time is actually stored as a number which increments by 1 each day (starting on 01/01/1900

So, 1 hour = 1/2
1 minute = 1/1440 (60*24
1 second = 1/86400 (60*60*24

So, to add 1 mnute to your cycle time (if the cycle time is held in A1 and the incrementer is in D1 as a general number), you would use =A1+(D1/1440

Hope this makes things a bit cleare

Geoff
 
Back
Top