Columns formatting
 

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 a
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.

Columns formatting
 

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

"Maksko" wrote in message
...
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 a
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.

Columns formatting
 

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

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

On Feb 2, 7:44 am, Maksko wrote:
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 a
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.