How do I convert time?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

N. Roheda - 11 Oct 2007 11:57 GMT

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?

Reply to this Message

Mike H - 11 Oct 2007 12:07 GMT

Multiply the time by 24 and format as general.

Mike

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

Reply to this Message

David Biddulph - 11 Oct 2007 13:24 GMT

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

Signature

David Biddulph

> Multiply the time by 24 and format as general.
>
> Mike

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

Reply to this Message

Sandy Mann - 11 Oct 2007 13:21 GMT

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

Signature

HTH

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

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

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

Reply to this Message