![]() |
|
#1
|
|||
|
|||
|
I have an Excel sheet with a start time field that is formatted as "HH:mm". I also have a Word document with information about a person's start time at an event. When I insert the merge code the field shows 0.8125. So it is not even in the normal hours/minutes/seconds format. When I toggle field codes I get { MERGEFIELD Start_Time }. I then enter a switch to the field code { MERGEFIELD Start_Time \@"HH:mm"} and then update field. I get the same result of 0.8125. Any ideas on how to get this to work for me? Thank you in advance for taking the time to look at this.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
how to format a picture switch in a merge field to only include the numbers in the middle?
|
becca | Mail Merge | 2 | 06-08-2016 01:15 PM |
Add Time Code
|
ossosso | Word | 14 | 01-07-2016 05:10 AM |
a code to add altering time to cells
|
tesoke | Excel Programming | 3 | 12-17-2015 12:31 PM |
| To me the code on the youtube tutorial looks the same as mine but a I get a run-time | chrisd2000 | Excel Programming | 1 | 07-02-2014 11:23 AM |
| my Outlook Calendar didn't switch to Standard time... | kali90 | Outlook | 0 | 03-12-2013 08:02 AM |