Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format(Time, "h.mm AM/PM") question
Here is the code:
'This is the name of the workbook with transferred data. This allows a date/time stamp in the name. wbname = "TERData " & Format(Date, "mm-dd-yyyy") & " " & Format(Time, "h.mm AM/PM") It stops on the word: TIME. why? This has worked for weeks and today it stopped working. I can't see anything that I changed in this line that would affect the outcome except I moved the code from a private open workbook macro into my private stash to test the email functionality on select memebers of my team. Here is a section of my log that also captures date and time the same way. You can see how the code use to work and now doesn't as the time switches to 12am and doesn't move forward: TERData 42 7/5/2006 8:54:39 AM TERData 43 7/5/2006 8:55:16 AM TERData 44 7/5/2006 12:00:00 AM TERData 45 7/5/2006 12:00:00 AM TERData 46 7/5/2006 12:00:00 AM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need calculated time in a "real number" format | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How can I format elapsed time as "[mm]: ss" without getting "AM PM | Excel Discussion (Misc queries) | |||
"Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) |