MINUTES TO HOURS

[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...

 

[Peo Sjoblom]

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

 

[Dan E]

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

 

[Dan E]

=A1/1440

or

A1/24/60

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

Yours is much simpler...