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

Hello ro from Steve3d

Justa couple cannot use VBA and memory this one is 64

It will only be ma matter off time where their will be no
difference between desktop and Pocket Computers
Which i'll be happy about, the latest edition allows portrait to landscape
veiwing so to my way off thinking it is going in the right direction.

"Ron Rosenfeld" wrote:

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