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?