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?