Formula to calculate elapsed time

Hi,

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. 

Example:

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?

 

Thanks,

Jim

By: Jim

Leave a Reply

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