convert length of time to minutes from hundreths
 

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?

convert length of time to minutes from hundreths
 

Divide by 24 and format as hh:mm or [hh]:mm


--


Regards,


Peo Sjoblom




"JICDB" wrote in message
...
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?

convert length of time to minutes from hundreths
 

Thanks! that was so easy I can't believe I couldn't figure it out.

"Peo Sjoblom" wrote:

Divide by 24 and format as hh:mm or [hh]:mm


--


Regards,


Peo Sjoblom




"JICDB" wrote in message
...
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?