Monday, November 26, 2012

yogi_Computer Number And Amount Of Transactions Conducted After Specified Hour


                                          Google Spreadsheet   Post  #896

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 26, 2012
user mqoue said:(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/BDWGuGnxbVE)
Managing Timestamp Data
Hello,

I have a small sample of timestamps transaction that I'd like to get some information out of.  I'd like to figure out what percent of these transactions took place after 5 pm? and I'd like to see what percentage of payout vs total was paid out after 5 pm

The link to the data is right here:
https://docs.google.com/a/mqoue.com/spreadsheet/ccc?key=0AlbhsLTIt0yMdEhXaGlVV1UzUk9MOGFiSFc3WW5EMkE#gid=0

Thanks in advance,

Robert

---------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem