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.