Converting Time!!

  • Thread starter Thread starter Kayty
  • Start date Start date
K

Kayty

Greetings,
Is there a function or something that will convert time to a numbe
i.e. from 00:01:00 to 1.00? and/or maybe a formula to calculate cos
per minute i.e. 20c per minute?
Thank
 
Hi

Multiply the time by 60 and then 24. This, when displayed as General, will
give you what you want
 
You must log in or register to reply here.

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

Subtracting time...again 2
Lookups 1
Converting time to Minutes 2
separating date and time 5
Calculating Phone Bills Help Please 4
calculating average handling time 7
How to convert time expressed as a decimal to actual hours or minu 8
Countifs with different restrictions 1

Back
Top