1430 to 2:30pm

[Guest]

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.

 

[Guest]

From Steved

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

 

[Bob Phillips]

or

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

 

[Guest]

Hello Bob from Steved

Much Cleaner.

Thankyou.

or

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

 

[Ron Rosenfeld]

or

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

or

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

format as time


--ron

 

[Guest]

Hello Ron from Steved

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

Thankyou very much indeed.

 

[Ron Rosenfeld]

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

 

[Guest]

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.