Converting time formats in Excel
oops. click the post button too quick.
note: excel keeps time as a percentage of a day so 1:15 is 0.052083333% of a
day. so multiply the time (as a percentage of a day-see above) times 60
minutes times 24 hours which should yield 75 formated as general.
regards
FSt1
"Darrin" wrote:
I am trying to get a throughput value from a time to volume ratio.
For example;
I have the working time of 1:15 and want to divide my volume of 3200 into it
to get a through put value.
What i would really like is to figure out a way to convert time formats from
the standard HH:MM to just minutes, ie: 1:15 (1 hour 15 minutes) to be 75
minutes.
|