Hello from Steved

Yes I have it VBA

Here is my issue I have A Pocket Computer with excel, it does not support VBA

Ok in cell B6 I type in 1430 I hit the enter key I need it to change to
2:30pm

I am wondering if this can be done. ie is thier a formula that could be used.

Thankyou.

From Steved

=TIME(LEFT(TEXT(A1,"0000"),2),RIGHT(TEXT(A1,"0000" ),2),0)


"Steved" wrote:

Hello from Steved

Yes I have it VBA

Here is my issue I have A Pocket Computer with excel, it does not support VBA

Ok in cell B6 I type in 1430 I hit the enter key I need it to change to
2:30pm

I am wondering if this can be done. ie is thier a formula that could be used.

Thankyou.

or

=TIME(INT(A1/100),MOD(A1,100),0)

--
HTH

Bob Phillips

"Steved" wrote in message
...
From Steved

=TIME(LEFT(TEXT(A1,"0000"),2),RIGHT(TEXT(A1,"0000" ),2),0)


"Steved" wrote:

Hello from Steved

Yes I have it VBA

Here is my issue I have A Pocket Computer with excel, it does not
support VBA

Ok in cell B6 I type in 1430 I hit the enter key I need it to change to
2:30pm

I am wondering if this can be done. ie is thier a formula that could be
used.

Thankyou.

Hello Bob from Steved

Much Cleaner.

Thankyou.

"Bob Phillips" wrote:

or

=TIME(INT(A1/100),MOD(A1,100),0)

--
HTH

Bob Phillips

"Steved" wrote in message
...
From Steved

=TIME(LEFT(TEXT(A1,"0000"),2),RIGHT(TEXT(A1,"0000" ),2),0)


"Steved" wrote:

Hello from Steved

Yes I have it VBA

Here is my issue I have A Pocket Computer with excel, it does not
support VBA

Ok in cell B6 I type in 1430 I hit the enter key I need it to change to
2:30pm

I am wondering if this can be done. ie is thier a formula that could be
used.

Thankyou.

On Mon, 12 Sep 2005 09:47:12 +0100, "Bob Phillips"
wrote:

or

=TIME(INT(A1/100),MOD(A1,100),0)

or

=--TEXT(A1,"00\:00")

format as time


--ron

Hello Ron from Steved

This formula off yours will do nicely for a mobile Pocket Computer.

Thankyou very much indeed.

"Ron Rosenfeld" wrote:

On Mon, 12 Sep 2005 09:47:12 +0100, "Bob Phillips"
wrote:

or

=TIME(INT(A1/100),MOD(A1,100),0)

or

=--TEXT(A1,"00\:00")

format as time


--ron

On Mon, 12 Sep 2005 16:59:12 -0700, Steved
wrote:

Hello Ron from Steved

This formula off yours will do nicely for a mobile Pocket Computer.

Thankyou very much indeed.

You're welcome. I'm not conversant with all the limitations of a pocket PC.


--ron