merge times in publisher catalog merge
I using Publisher Catalog merge to create certificates for our swimming club with the kids times recorded on them. But when I merge times with hundreds of seconds that are over 60 seconds the hundreds of seconds are rounded up - for example 1.75 will become
2.15. I'm merging out of excel where the cells are formatted as mm:ss.00 and appear correct - it's only when they are merge that this happens - I'm sure I've had this problems in previous years I just can't remember how I solved it!
January 22nd, 2014 5:36pm
How did you set the time as 1.75 in Excel? Does 1.75 means 1 minute and 75 seconds?
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2014 2:44pm