Git Hour Tracking

Recently I was asked to estimate how many hours I worked on a project. Since I hadn't really tracked them I decided to use the Git history to get an indication.

It turned out it was trickier than I thought to wrestle git log into producing a list that was somewhat useful, but here is a screen of what i ended up with:

This list makes it pretty easy to filter by author with |grep kevin, to only show what days I worked and what times I left (|sort -uk1,1) and how early I started (|tail -r |sort -uk1,1), or copy to a spreadsheet editor for further processing.

Here is the Git log command I used to produce the list:

git --no-pager log \
  --date=iso \
  --since="2 months" \
  --date-order \
  --full-history \
  --all \
  --pretty=tformat:"%C(cyan)%ad%x08%x08%x08%x08%x08%x08%x08%x08%x08 %C(bold red)%h %C(bold blue)%<(22)%ae %C(reset)%s"

Since we can't use a custom dateformat but really want to, the hack is to use ISO format (which comes closest to what we want), and add backspace characters (%x08). I stole that from stackoverflow.

I saved this to a file in my $PATH so now in any repository I could type:

git-timetracker.sh 2 years

I also tried making a Git alias in my ~/.gitconfig (not just calling the .sh script) but it was too damn hard :) Maybe you want to take a stab at it, I'm welcoming improvements!