time clock

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

Guest

What formula will convert time into a rounded 2 place decimal number? For example, how can I convert 8:30 to 8.50? or 8:10 to 8.17?
 
=ROUND(A1*24,2)

where A1 holds the time value

--

Regards,

Peo Sjoblom


Pamela said:
What formula will convert time into a rounded 2 place decimal number? For
Click to expand...
example, how can I convert 8:30 to 8.50? or 8:10 to 8.17?
 
Hi

With time in A1
=A1*24
format the result cell as 2 decimal number (-it will default as time and display 00:00
after entering the formula. Don't panic, just format).

--
HTH. Best wishes Harald
Followup to newsgroup only please.

Pamela said:
What formula will convert time into a rounded 2 place decimal number? For example, how
Click to expand...
can I convert 8:30 to 8.50? or 8:10 to 8.17?
 
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

Counting number of days up to an empty cell then start over again 1
Need to convert hours and minutes to hours and tenths. 2
Rounding time UP to nearest fourth-hour 4
Help! creating code for time to decimal calculations 1
Adding Hours Worked Correctly 3
Which is the best MBOX Converter Tool different formats conversion? 4
Help! creating code for time to decimal calculations 1
Excel vs Access Rounding 1

Back
Top