time clock

P

Pamela

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?
 
P

Peo Sjoblom

=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?
 
H

Harald Staff

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?
 
Top