Skip to content

Instantly share code, notes, and snippets.

@gavinblair

gavinblair/formulas.txt

Created August 3, 2012 14:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gavinblair/3248399 to your computer and use it in GitHub Desktop.
Save gavinblair/3248399 to your computer and use it in GitHub Desktop.
Download ZIP
What time today will all these bugs be done?
Raw
formulas.txt
=if(roundup(HOUR(GoogleClock())+1+G1)>24; "Another Day";if(roundup(HOUR(GoogleClock())+1+G1)>12; concatenate(roundup(HOUR(GoogleClock())+1+G1)-12;"pm"); concatenate(roundup(HOUR(GoogleClock())+1+G1);"am")))
G1
=sum(D:D)
D column contains the Estimated Time Remaining for each bug
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment