Using time totals in calculations

  • Thread starter Thread starter TLeBlanc
  • Start date Start date
T

TLeBlanc

I'm trying to find a way to utilize "total time" in minutes in telecom
usage/billing analysis. Currently, I "round" to the nearest minute and
just go on. But I'm curious if there is an easy way to actually enter
the total time (such as 1,239:32 or 1,239 minutes and 32 seconds) and
then convert it to a decimal value when calculating the per-minute rate
(by dividing into the usage cost).

I've seen the use of HOUR and MINUTE/60 to convert hours and minutes to
a decimal "hours" value, but I haven't seen one for "minutes", which is
what I need.

Terry
 
I'm trying to find a way to utilize "total time" in minutes in telecom
usage/billing analysis. Currently, I "round" to the nearest minute and
just go on. But I'm curious if there is an easy way to actually enter
the total time (such as 1,239:32 or 1,239 minutes and 32 seconds) and
then convert it to a decimal value when calculating the per-minute rate
(by dividing into the usage cost).

I've seen the use of HOUR and MINUTE/60 to convert hours and minutes to
a decimal "hours" value, but I haven't seen one for "minutes", which is
what I need.
Click to expand...


Enter the data so that Excel recognizes it as a time -- your number should be
entered either as 0:1239:32 or as 1239:32.0 in order to be interpreted as 1,239
minutes and 32 seconds. Custom format the cell in which you enter the data as
[mm]:ss.

To convert that number to "decimal time", multiply by 24*60 or 1440. Format
that cell as General (or a currency format) as Excel will initially format it,
too, as time.


--ron
 
Back
Top