Price time to cost
"Linda" wrote:
In A1 00:27:25 (which is time hh:mm:ss)
In B1 0.488p ( which is the cost)
In C1 - I have to charge the time by the cost
[....]
The above should come out to 13.29pence
I assume B1 is cost per minute; and I assume B1 actually contains the number
0.488. Then C1 is:
=A1*B1*1440
or better:
=round(A1*B1*1440,2)
But with those numbers, I get about 13.38, not 13.29. Is 13.29 a mistake?
Explanation: time (hh:mm:ss) is stored as a fraction of a day. Convert to
minutes by multiplying by the number of minutes in a day, namely 24*60
(1440).
If A1*B1*1440 does not work for you, it might be because B1 does not have
the cost as a number. If so, please clarify in a follow-up for additional
guidance.
----- original message -----
"Linda" wrote in message
...
Can any one please advise me how I can do the following
In A1 00:27:25 (which is time hh:mm:ss)
In B1 0.488p ( which is the cost)
In C1 - I have to charge the time by the cost but what ever I have done
it
does not work the same as doing via a calculator which I do not want to do
as
I have over 8,000 in my spread sheet.
The above should come out to 13.29pence
Thank you in advance
|