Employee Time Sheet

Saw this as an option for a time sheet. I get the parent/child rows and how all the math works. What i dont get is how each of the parent rows are created, if i have a form for employees to submit each week with their time entered.


Answers

  • Razetto
    Razetto ✭✭✭✭✭✭

    @Robert S Fike Hi, I think that such template is manually modified, I'll guess that it has a form associated and new entries go at the bottom of the sheet and then the row is moved under the respective employee and then it's indented.

    Another way of doing it is to create a sheet to gather the employees submittals thru a simple form, and a second sheet where you do the calculations, employees name in column A and the other columns can be anything you want like total hrs. or $ per quarter or monthly, sick pay...

  • Robert S Fike
    Robert S Fike ✭✭✭✭

    Thank you very much.