Monday, June 26, 2017

yogi_Count responses per hour in google forms spreadsheet

Google Spreadsheet   Post  #2194
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-26-2017
question by zeke29:
https://productforums.google.com/forum/#!topic/docs/83vr5nLeSp8;context-place=forum/docs
Count responses per hour in google forms spreadsheet
I have a google forms where I capture the user's email and I need to count how many responses are submitted per hour by each email (user). 

Forms enters a time stamp in the form of 

MM/DD/YYY HH:MM:SS

I assume that I just need to capture the HH part of the time stamp and count the occurrences for each email but I'm not sure how to do that. Any help? 

Thanks

No comments:

Post a Comment