View Single Post
 
Old 12-20-2016, 11:51 AM
Ozzie2842 Ozzie2842 is offline Windows XP Office 2007
Novice
 
Join Date: Aug 2013
Posts: 1
Ozzie2842 is on a distinguished road
Default Field Code/Switch for Time not working

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.
Reply With Quote