time clock

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

 

[Peo Sjoblom]

=ROUND(A1*24,2)

where A1 holds the time value

--

Regards,

Peo Sjoblom

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?

 

[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.

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?