View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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.