Time Formulas

**notquite** · 02-20-2011, 09:48 PM

Formula A2*1.25
A2 is = 0:00:35 and B2 is $1.25 per minute, then answer should equal $0.44.
With formula A2*1.25*1440, I get $0.73.
What I want is to multiply secs and mins by $1.25
Any more suggestions and why the differences?

**Ron Coderre** · 02-20-2011, 10:05 PM

Even though Excel displays times, it actually stores times (anything less than a day) as a decimal fraction of 1.

Examples:
Noon...12:00:00...is actually 0.5
4:15 AM..............is: 0.177083333333333

Perhaps if you describe what you want to do (with an example or two), we'll be able to offer specific assistance.

**daddylonglegs** · 02-20-2011, 10:31 PM

Is 1.25 the rate per minute? If so then you need to multiply by 1440 (the number of minutes in a day), e.g. if you have the time value in A2 and the rate per minute in B2 try this formula in C2

=A2*B2*1440

format C2 as currency

**notquite** · 02-20-2011, 10:40 PM

What would the formula look like if
CELL B(time format) x CELL C = CELL D(currency format)

Cell A Cell B Cell C Cell D
14/02/2011 0:00:35 1.25 $0.44
14/02/2011 0:01:58 1.25 $1.98
14/02/2011 0:02:24 1.25 $2.80
14/02/2011 0:03:03 1.25 $3.79
14/02/2011 0:09:17 1.25 $11.46
14/02/2011 0:04:27 1.25 $5.34
14/02/2011 0:04:10 1.25 $5.13
14/02/2011 0:03:47 1.25 $4.34
14/02/2011 0:06:17 1.25 $7.71
14/02/2011 0:13:06 1.25 $16.33
14/02/2011 0:03:28 1.25 $4.10
14/02/2011 0:02:12 1.25 $2.65
15/02/2011 0:07:53 1.25 $9.41
15/02/2011 0:05:17 1.25 $6.46
16/02/2011 0:08:02 1.25 $10.03
16/02/2011 0:07:38 1.25 $9.23
16/02/2011 0:02:41 1.25 $3.01

**notquite** · 02-20-2011, 11:03 PM

Thank you Daddylonglegs.

Formula seems to work but if A2 is = 0:00:35 and B2 is $1.25 per minute then C2 should equal $0.44. With your formula I get $0.73. Why is the difference?

Pam