Quote:
Originally Posted by gmayor
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.
|
i opened your document, but that's not what i look for.
there is 31 days in that table,user will key in the wokring hours at day 3 but not day 1 and 2.
Is that got a way to do, like the user select the day 3, and key in the time, after that when the user hv work at day 6 or the other day, the user just select that day and thn key in the time, the hours will auto display?