Converting Minutes to hours and mintues

  • Thread starter Thread starter Branagan1985
  • Start date Start date
B

Branagan1985

My question is

say i have a number representing minutes
how do i convert it to hours and minutes eg/

140 minutes = 2h20m

or something similar, cheers in advanc
 
Easiest way is to convert to Excel time value (decimal fraction of a day)

=minutes/24/60

and format as time. Format|Cells|Number|Custom and enter either
[h]:mm
or if you want it to appear exactly as "2h20m", then use
[h]"h"mm"m"

Jerry
 
Jerry said:
*Easiest way is to convert to Excel time value (decimal fraction of
day)

=minutes/24/60

Jerry
*
Click to expand...
[/QUOTE]

hi jerry

i did the format fine - cheers

but i dont understand the first part you said, how do i do that bit ?

say if my number was

130

what would i have to do to convert it to 2hr 10
 
Hi Branagan1985!

Where A1: 130

=A1/(24*60)
Format h"hr "m"m"

You need to appreciate the Excel date / time serial number system.
Dates are serial numbers representing the number of days since
31-Dec-1899. The decimal part of a number is used to represent time
with (eg) .25 being 6:00AM.

You have a whole number of minutes. Excel regards the whole number as
days. Dividing by (24*60) converts the 130 to the decimal part of 1
day. The formatting, just "tells" Excel how to represent this decimal
number on the screen or print out.
 
Back
Top