How do I convert time?

N

N. Roheda

Hi, I like to convert 4,30 to 4,5, I type in 4,30(4m & 30s) and I want to get
out a dec. of 4,5. This is because it should be easy to type in the data? Is
it pssible?
 
S

Sandy Mann

I the comma is your decimal symbol then use:

=INT(A1)+MOD(A1,1)*100/60

If not then use:

=LEFT(A1,FIND(",",A1)-1)+RIGHT(A1,LEN(A1)-FIND(",",A1))/60

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
D

David Biddulph

But you need to type in the time as 4:30, not as 4,30 (unless your settings
have non-standard defined separator characters).
 
Top