Formula to calculate elapsed time


I have a spreadsheet with start and stop work time for each date worked. I know how to calculate the time worked for each day individually but want to track it as a running total of time worked each week. 


Monday- start (column b5) and stop time (column c5)=total hours worked (column d5)on Monday

Tuesday-start (column j5)  and stop time (column k5) = total hours worked plus total hours from Mondays for current week total hours (column l5).

I am having great difficulty with a formula for column I5. 

Is there anyone who can assist with the formula?




By: Jim

Leave a Reply

Your email address will not be published. Required fields are marked *