View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Minute Conversion

We are given a report that is showing a sum hours and minutes like this
00:23:00 like hh:mm:ss. First I need to now how to convert that into
minutes in decimel format such as 45.67 min. I then need to be able to add
subtract and multiply theses numbers.. I have tried all of the conversion
formulas and have had no luck.. Help please

BOb