Home

Times formatted cells that are then being used to mail merge

%3CLINGO-SUB%20id%3D%22lingo-sub-304599%22%20slang%3D%22en-US%22%3ETimes%20formatted%20cells%20that%20are%20then%20being%20used%20to%20mail%20merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304599%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20can%20help.%20I%20have%20an%20Excell%20speadsheet%20with%20A%2FL%20hours%20%26amp%3B%20minutes%20worked%20out.%20When%20I%20was%20researching%20the%20best%20formatting%26nbsp%3Bwas%20for%20this%2C%20the%20best%20I%20could%20find%20was%20Custom%20field%20%5Bh%5D%3Amm%20(I%20changed%20it%20to%20%5Bhh%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20now%20I%20am%20on%20the%20next%20stage%20of%20the%20A%2FL%20and%20I%20am%20trying%20to%20mail%20merge%20all%20of%20the%20details%20across%20in%20to%20word.%20When%20mail%20merging%20the%20time%20formatting%20doesn't%20come%20across.%20I%20have%20tried%20editing%20the%20fields%20codes%20in%20multiple%20ways%2C%20but%20none%20produce%20the%20actual%20same%20time%20figures%20that%20the%20spreadsheet%20does%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304605%22%20slang%3D%22en-US%22%3ERe%3A%20Times%20formatted%20cells%20that%20are%20then%20being%20used%20to%20mail%20merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304605%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20afraid%20no%20luck%20there%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304601%22%20slang%3D%22en-US%22%3ERe%3A%20Times%20formatted%20cells%20that%20are%20then%20being%20used%20to%20mail%20merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304601%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20check%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fword.tips.net%2FT003878_Controlling_Date_Formats_in_a_Mail_Merge.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fword.tips.net%2FT003878_Controlling_Date_Formats_in_a_Mail_Merge.html%3C%2FA%3E.%20That's%20about%20date%20format%2C%20but%20with%20time%20idea%20is%20the%20same.%20I%20guess%20for%20the%20time%20mergefield%20format%20will%20be%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%5C%40%20%22HH%3Amm%22%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
heraldfreak
New Contributor

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

2 Replies

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"

Im afraid no luck there

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies