Calculate time and cost

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Lasse,

Time is stored as a fraction of a day. So to get the number of minutes,
multiply by 24*60 (=1440)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Price time to cost 9
Calculating Cost Per Minute 5
Calculating payroll cost 1
Help on randomly selecting cells to SUM 2
Calculating Phone Bills Help Please 4
Total sum based on different costs for each new quantity group 3
Financial Time Value of Money calculations 5

Back
Top