View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JICDB JICDB is offline
external usenet poster
 
Posts: 91
Default 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?