ExcelBanter - Time Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time Question (https://www.excelbanter.com/excel-discussion-misc-queries/134434-time-question.html)

metaltecks

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?

RichardSchollar[_2_]

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?

Stefi

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?

All times are GMT +1. The time now is 04:13 PM.