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
|