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

https://docs.google.com/spreadsheets/d/1dD1ZbSDhprviJ1sO-mtUopOuq-XCyAXD9kzel-GN_Do/edit?usp=sharing

Any help will be appreciated 

Thanks.