MINUTES TO HOURS

  • Thread starter Thread starter Malcolm Austin
  • Start date Start date
M

Malcolm Austin

Hi, I know I've seen this before on the newsgroup !

I have a table (Excel 2000) for my flights and gliding time (K6CR for anyone
who knows) and need to total the minutes to hours and minutes.

I'm going round in circles and not getting very far !! Could someone let me
know the formula/cell formatting I require to do this. Also could I then
just add two cells together to get a combined total?

Thanks.

Malcolm...
 
Assuming you have integer minutes like for instance 185 minutes in cell A1

=A1/1440

or

A1/24/60

then format the cell as hh:mm

if you are totalling all time and it is greater than 24 hours use [hh]:mm
 
Malcolm,

You can use:

=TIME(INT(A1/60),MOD(A1,60),(A1-INT(A1))*60)

where A1 contains you time in minutes

INT(A1/60) returns the number of hours
MOD(A1,60) returns the remaining minutes
(A1-INT(A1))*60 returns the seconds

Dan E
 
Back
Top