View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Al Gillis
 
Posts: n/a
Default 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