How do I convert time?

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

Guest

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
But you need to type in the time as 4:30, not as 4,30 (unless your settings
have non-standard defined separator characters).
 
Back
Top