Hours to Minutes

  • Thread starter Thread starter JimS
  • Start date Start date
What you need to know is that Excel store time as a fraction of a day
So to convert 1:17 to minuets use =A1*24*60
To divide by 20: =A1*24*60/20 or =A1*24*3
best wishes
 
With 1:17 in A1,
To return minutes:

=A1*1440

And to divide by 20:

=A1*1440/20
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


How to I turn 1:17 into minutes?

Also, how would I divide 1:17 by 20 (minutes)?
 
You can do this with a custom format.

XL2003:
http://office.microsoft.com/en-us/excel/HP051995001033.aspx?pid=CH010036911033
XL2007
http://office.microsoft.com/en-us/excel/HP012165031033.aspx?pid=CH100870371033#2

The custom format to use is '[m]' (without the quotes).

Note that formatting changes the appearance without affecting your
underlying value. SO, it will not affect time mathematics.

OR multiply the value:

=A1*24*60 (note 24 hours in a day, 60 minutes in an hours)
This increases the value to a decimal.

OR use a combination

=--TEXT(B5,"[m]") - the double negative changes a string to a number.
This also increases the value to a decimal.


Division is straightforward:

If A1 has 1:17 and A2 has 0:20 then A1/A2 = 3.85

You may need to format the answer to a number to see the above result.


This should help you understand time calculations:
http://www.cpearson.com/excel/datetime.htm
 
Back
Top