With time in a1, and cost in a2, the cost per minute is:
=a2/(a1*1440)
--
Regards,
Fred
Please reply to newsgroup, not e-mail
"Sjoestaal" wrote in message
...
I would like to calculate the cost per minute. I have column with time,
hh:mm:ss, and a column with costs in swedish Krona. How do I divade the
cost
with the time? I would like to know how much each minute of work costs.
Whatever I try the result ends up wrong.
The time is larger then 23:59:59 (i.e 133:25:00).
Appreciate any help!
Lasse
|