View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default totaling phone minutes

Hi Rebecca

If you are trying to sum minutes, and then use the value to multiply by a
cost, you need to multiply by 1440.
Excel stores Time as a fraction of a day.
So to convert 1:40 to decimal minutes (100) multiply the cell by 24 to get
to hours, then by 60 to get to minutes (24*60=1440)

--

Regards
Roger Govier

"rebecca" wrote in message
...
How do I get a total for phone minutes? What would be the formula?

Rebecca