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

9 thoughts on “Formula to calculate elapsed time


    Does your site have a contact page? I’m having a tough time locating
    it but, I’d like to shoot you an e-mail. I’ve got some suggestions for your blog you
    might be interested in hearing. Either way, great site and I look forward to seeing it
    grow over time.

  2. quest bars cheap

    I really like your blog.. very nice colors & theme.
    Did you design this website yourself or did you hire someone to do it for you?

    Plz respond as I’m looking to construct my own blog and would like to know where u got this from.
    many thanks

  3. Elden Waugh

    Aw, this was a really nice post. In idea I would like to put in writing like this additionally ? taking time and actual effort to make a very good article? but what can I say? I procrastinate alot and by no means seem to get something done.

  4. sling tv

    Oh my goodness! Incredible article dude! Thank you, However I
    am encountering problems with your RSS. I don’t understand why I am
    unable to subscribe to it. Is there anybody else getting identical RSS issues?
    Anybody who knows the solution will you kindly respond?

Leave a Reply

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