Sunday, November 27, 2011

yogi_Pull Data For Certain Actions By Month Using Info From Timestamp

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user FroSho21 said:
I need to figure out how to pull data for certain actions for each month, using the time stamps?
Timestamp           Time Spent on Procedure    Reason for Visit
2/20/2011 19:00:45               30            Heliox with High Flow Nasal Cannula   
2/10/2011 19:00:45               35            Heliox
2/8/2011  19:00:45               90            Intubation
2/8/2011  19:00:45               70            Level 1 Trauma
10/18/2010 2:00:45               15            Home Care Vent/Trach Patient
An additional question would be is there a way I can count the total number of each procedure per month per year?So I am trying to pull monthly totals of time for each type of procedure but I also need to divide it between the years 2010, 2011, etc....
Thank you!Thank you all for your help, you have been transition to utilizing google docs and google forms has been great thanks to help from individuals such as yourselves.

following is one solution to the problem