Running Excel 2010
Our manufacturing process is start heating metal, stop heating metal, start pouring metal, stop pouring metal. For my purposes "stop heating" and "start pouring" are the same. So I have 3 time values to enter and I want 3 calculated time durations. Length of heating cycle, length of pouring cycle and time between last "stop pouring" to the next "start heating" cycle.
Raw data is manually entered into one sheet. It's only for me, so style/format doesn't matter. The duration can be displayed as minutes or decimal hours.
I tried several different ways to format the entered time values but the simple calculations for duration don't work. Right now the time values are formatted as numbers, which works just as well as anything else so far...
I'll be surprised if I have to apply a custom (if > 60 then -60) type of function but I can't find any canned formulas for getting these durations without the predictable time/number conversion problems. Likewise, I could convert from hours:minutes to hours.hours but do I really have to?
Thank you for your help.
Bookmarks