Time Question

M

metaltecks

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?
 
R

RichardSchollar

Hi

Assuming that value in A1 then you could use:

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

Best regards

Richard
 
S

Stefi

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


„RichardSchollar†ezt írta:
 
Top