converting a sum of minutes to...

  • Thread starter Thread starter jeanjean682003
  • Start date Start date
J

jeanjean682003

an HH:min format.
I'm presently analysing and building my 2003/04 multi sport calendar.
Is there an excel formula to convert a sum of min. ( 378 min to 3:18
)?
thanks
Jeanjean
 
an HH:min format.
I'm presently analysing and building my 2003/04 multi sport calendar.
Is there an excel formula to convert a sum of min. ( 378 min to 3:18
)?
thanks
Jeanjean
Click to expand...

Well, it depends on what you mean by 3:18 <g>

If you mean 3 hours 18 minutes, then we have to know if you always want to
subtract three hours from your minutes total, as 378 minutes is 6 hours 18
minutes.

If it's a typo, and you really meant 6:18, then divide by 1440 and format the
cell as [h]:mm.

If 378 is in A1, you could put the formula =A1/1440 in B1.

Then right-click on B1 and choose Format Cells from the right-click menu.
Then Number/Custom/Type: and enter [h]:mm in the box.

<OK> and you're done.


--ron
 
thanks guys,
Yes ron it was a typo, I meant 6hrs 18
I saw the "light" (the excel one, not god). it reads and converts by
segments of 24 hours.
great and thank you very much for this fast response
Jeanjean
Cheers from toronto!
 
Back
Top