Columns formatting

[Guest]

Hi to all,


I have needed advice or maybe a formula for cell or columns formatting,
Namely I have cell with numbers and they could be cells for time (hh:mm:ss)


For example
If I have column with numbers:

Example:
Time
84233
112535
5231
5623
65236
103523
163526
225324

The results that I would like to have are:
Time
084233
112535
005231
005623
065236
103523
163526
225324

OR

Time
08:42:33
11:25:35
00:52:31
00:56:23
06:52:36
10:35:23
16:35:26
22:53:24

The same column, but formatted like time

I hope that you are going to help me, giving me advice how can I do this or
maybe the problem can be solved by formula.

Thank you.

 

[David Biddulph]

=TIME(A1/10000,MOD(A1/100,100),MOD(A1,100)) and format as hh:mm:ss

 

[Lori]

Either use a custom number format for the cells in the column: 00\:00\:
00
or a formula:

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