How do I convert time?
 

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?

How do I convert time?
 

Multiply the time by 24 and format as general.

Mike

"N. Roheda" wrote:

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?

How do I convert time?
 

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


Replace @mailinator.com with @tiscali.co.uk


"N. Roheda" <N. wrote in message
...
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?

How do I convert time?
 

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

"Mike H" wrote in message
...
Multiply the time by 24 and format as general.

Mike

"N. Roheda" wrote:

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?