Saturday, December 3, 2016
yogi_Compute Sum Of Weekly Hours Every Monday
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-03-2016
question by: Ramsey Persing:https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!msg/docs/UYB5AZCB-gU/MkedvMdEBgAJ
I'd love some help with a Google Sheet Formula if anyone has any ideas. I make my own hours and I created a simple Google Form to help me track my hours throughout the week. It only asks for the weekday and hours worked that day. The form filters all my answers to a spreadsheet. I'm trying to make a formula that automatically calculates the hours worked for that current week. It looks for the most recent occurrence "Monday", then sums all the hours after that.