| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Question
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Question
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Question | Excel Discussion (Misc queries) | |||
| Time question | Excel Discussion (Misc queries) | |||
| Time Question | Excel Worksheet Functions | |||
| Time Question | Excel Discussion (Misc queries) | |||
| Best time question | Excel Worksheet Functions | |||
Linear Mode
