Andrew, thank you so much for the updated code, it works perfectly. I initially searched the internet high and low for something like this but there was nothing at all for Word documents so hopefully this will benefit someone else looking to format times in documents. Thank you again for you help and patience as ever, best wishes, Shelley