Sunday, May 7, 2017

yogi_Flag With 'S' Row By Row If Time In Column B Plus Duration In Column C Is In Range Of Clock Time In Row 1

Google Spreadsheet   Post  #2158
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-07-2017
question by MatKa!#:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/GXVpoAYH2Ro;context-place=mydiscussions

Timesheet creation

 Hello

Im trying to create a timesheet and i need to mark the hours needed for each task with S

So i have the following columns : Name, Task, Time Start and Duration... What i need is, if Time Start is 10:00 and the duration is 3 to feel in with S the hours 10:00 - 13:00

Here is my example sheet for explanation


Any help will be appreciated 

Thanks.