Minutes into Hours and Minutes

  • Thread starter Thread starter david d
  • Start date Start date
D

david d

I have a spreadsheet which I use to keep the times of some events. I get
these numbers in minutes and need to convert them into HH:MM format.
 
Just divide your minutes value by 86400 (the number of minutes in a day)...

=A1/86400

and format the cell like this... [hh]:mm (the square brackets allow the
hours to be more than 24).
 
Do you mean you have 120 minutes and want to convert it to 2:00?

if so:

1) Divide your minutes value by 1440
2) Format the result as time.

Using XL2003, to do the latter:

Format, Cells click the Number tab and either select category:
a) Time and choose your format
OR
b) Custom and enter "[h]:mm" (without the quotes) in the Type dialogue box
to get values above 24 total hours. For example, entering 1500 minutes will
convert to 25:00
 
You work a long day <bg>

For David's benefit:

In Excel, 1 day = 1
Hours in a day = 1*24
Minutes in a day = 1*24*60 (1440)
Seconds in a day = 1*24*60*60 (86400)

--
Steve

Rick Rothstein said:
Just divide your minutes value by 86400 (the number of minutes in a
day)...

=A1/86400

and format the cell like this... [hh]:mm (the square brackets allow the
hours to be more than 24).

--
Rick (MVP - Excel)


david d said:
I have a spreadsheet which I use to keep the times of some events. I get
these numbers in minutes and need to convert them into HH:MM format.
Click to expand...
Click to expand...
 
LOL... looks like I multiplied by 60 one too many times. Thanks for catching
that.

--
Rick (MVP - Excel)


AltaEgo said:
You work a long day <bg>

For David's benefit:

In Excel, 1 day = 1
Hours in a day = 1*24
Minutes in a day = 1*24*60 (1440)
Seconds in a day = 1*24*60*60 (86400)

--
Steve

Rick Rothstein said:
Just divide your minutes value by 86400 (the number of minutes in a
day)...

=A1/86400

and format the cell like this... [hh]:mm (the square brackets allow the
hours to be more than 24).

--
Rick (MVP - Excel)


david d said:
I have a spreadsheet which I use to keep the times of some events. I get
these numbers in minutes and need to convert them into HH:MM format.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top