Dec 20 2018 01:18 AM
Hi,
I hope you can help. I have an Excell speadsheet with A/L hours & minutes worked out. When I was researching the best formatting was for this, the best I could find was Custom field [h]:mm (I changed it to [hh]
However now I am on the next stage of the A/L and I am trying to mail merge all of the details across in to word. When mail merging the time formatting doesn't come across. I have tried editing the fields codes in multiple ways, but none produce the actual same time figures that the spreadsheet does
Dec 20 2018 01:32 AM
Please check this https://word.tips.net/T003878_Controlling_Date_Formats_in_a_Mail_Merge.html. That's about date format, but with time idea is the same. I guess for the time mergefield format will be like
\@ "HH:mm"
Dec 20 2018 01:44 AM
Im afraid no luck there