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
|