Formatting values to be Times of day...
 

TIA for your help or reference links...

I've got a bunch of numbers (formatted as "general") I want to appear more
as time of day (no math needs to be done on these number)

For example, if my entries a
603
1851
720
1643
I want the resulting formated numbers to appear as:
06:03
18:51
07:20
16:43
(showing leading zeros where appropriate and colons)


Because these are just numbers I usually get results than look like dates
from early in the previous century!

Thanks!

Al

Formatting values to be Times of day...
 

You would need an event macro

http://www.cpearson.com/excel/DateTimeEntry.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Al Gillis" wrote in message
...
TIA for your help or reference links...

I've got a bunch of numbers (formatted as "general") I want to appear more
as time of day (no math needs to be done on these number)

For example, if my entries a
603
1851
720
1643
I want the resulting formated numbers to appear as:
06:03
18:51
07:20
16:43
(showing leading zeros where appropriate and colons)


Because these are just numbers I usually get results than look like dates
from early in the previous century!

Thanks!

Al

Formatting values to be Times of day...
 

In B1 enter:

=TEXT(LEFT(A1,LEN(A1)-2),"00")&":"&(RIGHT(A1,2))

And copy down.


"Al Gillis" wrote in message
:

TIA for your help or reference links...

I've got a bunch of numbers (formatted as "general") I want to appear more
as time of day (no math needs to be done on these number)

For example, if my entries a
603
1851
720
1643
I want the resulting formated numbers to appear as:
06:03
18:51
07:20
16:43
(showing leading zeros where appropriate and colons)


Because these are just numbers I usually get results than look like dates
from early in the previous century!

Thanks!

Al

Formatting values to be Times of day...
 

PERFECT, Jim!

Thanks for your quick and accurate response!

Al
"JimMay" wrote in message
news:OXXkg.41425$fG3.4132@dukeread09...
In B1 enter:

=TEXT(LEFT(A1,LEN(A1)-2),"00")&":"&(RIGHT(A1,2))

And copy down.


"Al Gillis" wrote in message
:

TIA for your help or reference links...

I've got a bunch of numbers (formatted as "general") I want to appear
more
as time of day (no math needs to be done on these number)

For example, if my entries a
603
1851
720
1643
I want the resulting formated numbers to appear as:
06:03
18:51
07:20
16:43
(showing leading zeros where appropriate and colons)


Because these are just numbers I usually get results than look like dates
from early in the previous century!

Thanks!

Al