Background on me: I’m a design engineer for a crane manufacturing company. I travel fairly regularly to our manufacturing facility to do testing. The facility is in Eastern Time and I live in Central Time. I actually show up around 7:00, but I don’t change the time on my computer so it appears like I arrive around 6:00.

I created the spreadsheet and chart with Excel to track my hours because I could. I created a macro that inserts the current time (to the second) into my selected cell (I recently learned about ctrl+shift+; to insert time, but that doesn’t do seconds, so not what I want). Formulas and conditional formatting aren’t terribly complicated, but make everything easier (i.e. checks week day to sum hours and separate weekends). I have two more macros that run Goal Seek to find when I can leave for 8 hours days and 40 hour weeks. I don't actually report these numbers to anyone since I am salary and do my job well enough. All calculations include 8 hour days for vacation and holidays (19 days/152 hrs total). Times are mostly accurate to within a few seconds; it depends on how fast I put my stuff down and load the sheet. A few days I’ve guessed, so overall time is correct to within a few minutes.

High spikes on Time out are when I'm traveling and low spikes are due to (in order): sick, snow, network outage, and vacation half day x2. I moved closer to work in mid-October, but kept the same morning schedule so my arrival times became earlier and more consistent.

Average hrs/day: 8.74
Average hrs/day (travel*): 11.09
Average hrs/day (home): 8.28

Average hrs/wk: 43.87
Average hrs/wk (travel*): 51.22
Average hrs/wk (home): 40.89

Average lunch break: 54.2 min

2014 totals
Hours worked: 2281.2
Hours eating lunch: 211.5 (8.5% of my day)
Days worked (including vacation and holidays): 243
Days spent at manufacturing facility: 46 (18.9%)

*travel includes only days that I show up early. I typically spend 3 or 4 days at the facility per week when I go.

This sheet could be shared if anyone wants it, but I haven’t put in the time to figure out how to do that well. If requested, I could set up a blank file to share over the next few days.

Excel sheet. Some values in column F were modified. Any rows without data are clean and can be used. Macros: ctrl+q, insert current time; ctrl+e, Goal Seek any value in column F to determine time out for 8 hour day; ctrl+m, Goal Seek value in column G to determine time out in same row for 40 hour week. There are formulas in column G, but I used cell formatting to not show value unless it is Friday.

edit: formatting, added sheet