Emily - I can't seem to come up with a format that appears far more complicated than this one, especially with a cell for every day for 4 months. Doesn't matter how I split it up, once you get a couple people in it the size of the spreadsheet gets large fast I want you to be able to use this however, so feel free to let me know if there is some other way that I can edit your portion of the spreadsheet to make it easier for you to use as I want it to be helpful..
The secret to this format is just remembering to visit the spreadsheet the day of your activity and add your hours to the existing total for the month. You can either do the math in your head OR set up a formula (something like =5+3+2+4+111) just remember the last character in the formula must be a number, not a plus sign, which enables you to enter every day's activity time for the month in one cell.



Reply With Quote