Skip to content

Instantly share code, notes, and snippets.

@benjaminhawkeslewis

benjaminhawkeslewis/gist:1333608

Created November 2, 2011 13:22
Show Gist options
  • Save benjaminhawkeslewis/1333608 to your computer and use it in GitHub Desktop.
Save benjaminhawkeslewis/1333608 to your computer and use it in GitHub Desktop.
Download ZIP
Gawking my time log
Raw
gistfile1.txt
gawk -F "\t" '{ split($1, times, "/") ; split(times[1], start_time, /[T:-]/); split(times[2], end_time, /[T:-]/); h = (mktime(end_time[1] " " end_time[2] " " end_time[3] " " end_time[4] " " end_time[5] " 00") - mktime(start_time[1] " " start_time[2] " " start_time[3] " " start_time[4] " " start_time[5] " 00"))/(60*60); t[$3] = t[$3] + h } END { for (tag in t) { printf "%-50s\t%.2f\n", tag, t[tag] } }' time\ log.txt
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment