Time Question
Another solution:
=TIME(LEFT(A1,2),RIGHT(A1,2),0)
Regards,
Stefi
€˛RichardSchollar€¯ ezt Ć*rta:
Hi
Assuming that value in A1 then you could use:
=TEXT(A1,"00\:00")+0
Best regards
Richard
On 12 Mar, 14:02, metaltecks
wrote:
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?
|