Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anaother time format question
I get text files from a phone switch. I then have a macro that does some
calculations and saves it as 2003 format .xls. I am using 2007. The times come across like: 8:48, which is actually 8:48:00 AM. However, some come across as :53, which stores as :53. I need it to be in the format of 12:53:00 AM, for calculations. If I manually put a 0 in front, 0:53, it stores fine, but I do not want to manually do this on hundreds of files, hundreds of entries every month. The concatenate into a different cell, saves it as text, so no calculations there. Is there VB formula that will change :53 to 12:53:00 AM which can be run on the whole file, changing only those that are less than a minute? If it can do it in the same cell, all the better, but if not, that's ok, too. Thanks, Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Format Question | Excel Worksheet Functions | |||
Date time format question please | Excel Discussion (Misc queries) | |||
One more question pay calcs using [h]:mm format for time worke | Excel Discussion (Misc queries) | |||
Time Format Input question | Excel Programming | |||
Time Format Question | Excel Worksheet Functions |