Excel - convert length of time to minutes from hundreths

Asked By JICD on 01-May-08 04:22 PM
I am trying to convert the amount of time - not the time in a time format -
to minutes from hundreths.  The flat file from the database reads the amount
of time as 1.50 which is 1 and a half hours.  Is there a formula that will
convert this to 1.30 for 1 hour and 30 minutes?

Peo Sjoblom replied on 01-May-08 04:27 PM
Divide by 24 and format as hh:mm or [hh]:mm



Peo Sjoblom
JICD replied on 01-May-08 05:53 PM
Thanks!  that was so easy I cannot believe I could not figure it out.