Converting minutes to hours and minutes

Converting minutes to hours and minutes

Post by wend » Wed, 15 Oct 2003 23:04:26


I am trying to find out the formulae or a way to show the
total hours and minutes of a cell which has the total
number of minutes. i.e. 91 minutes = 1:31 (1 hour, 31
minutes)
I'm sure it can be done quite easily but I;m having a bad
day. Can anyone help!

Thanks.
Wendy.
 
 
 

Converting minutes to hours and minutes

Post by Peo Sjoblo » Wed, 15 Oct 2003 23:17:35

One way

=A1/1440

format as hh:mm

--

Regards,

Peo Sjoblom