You have not askeda question as such, more many quiestions, poss people wont aswer all them, its kinda of a project.
OK i have timesheet that the guru of timesheets, i designed and another i stole, well was sent, both are very touchy twitchy and frawt with issues. so expert maintance is always required as any timesheet will.
check the web for such TEMPLATES or examples, i know no way to avoid VBA scripts and that bring BIG problems as its al time convertions ie base 60.
So guru Gurus (one i think of Chris before you say) could do this in formula but it a project and a half..
I give without question anythink i have away to use view whatever, but i dont really want to they are not very good in returning results, like sick and holidays all sorts.
Fix,, build VERY slowly, manula input and replace bit by bit and so wuill cover what you need, your then understand the codes and formulas so will be able to maintain.. just there is what you want might not do the trick.
ME! i would post a question a day if needs be and getthat help you need.. and i would love the challange.. im know for fact single questions GET RESULTS from readers and i know you get that help.
IF YOU REALLY REALLY must.. i can send you codes and sheets, but i do not recoment taking that offer, they can be difficult, but i do not want to say no or hide the facts. Just being honest a lot to be said for that.