Thread: [Solved] How to set the table cells as time format?
View Single Post
 
Old 11-14-2016, 11:07 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
It's not that simple but the attached should give you a start point, though I haven't tested it thoroughly. The hours in the various segments are rounded up to the next hour. Then macro will run when you open the document. Personally I would save the document as a template, change the AutoOpen macro to AutoNew and create new documents from it as required.
Attached Files
File Type: docm test.docm (46.9 KB, 9 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote