Time Question

[Guest]

I have field that is formatted as a general number. Ex. 2038
I need to have this number to show up as a time field. 20:38 or 10:38.

How can I do this?

 

[RichardSchollar]

Hi

Assuming that value in A1 then you could use:

=TEXT(A1,"00\:00")+0

Best regards

Richard

 

[Guest]

Another solution:
=TIME(LEFT(A1,2),RIGHT(A1,2),0)
Regards,
Stefi


„RichardSchollar†ezt írta: