+ Reply to Thread
Results 1 to 2 of 2

Multiplying and Adding times to determine Elapsed time (without the rollover effect)

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Fort Smith, AR
    MS-Off Ver
    2010
    Posts
    1

    Multiplying and Adding times to determine Elapsed time (without the rollover effect)

    Im trying to multiply and add times.

    For instance, cell F5 has value of 08:29 which represents the time that an employee works in one day.

    If the employee works the same shift for 5 consecutive days then I would like to have the total time worked placed in cell F6 (In theory I could do this by either having F5*5 or F5+F5+F5+F5+F5).

    I would like to see the value of 43:05 in cell F6 which would represent 43 hours and 5 minutes worked.

    However, whether I do multiplication or addition, Excel gives me the value of 19:05 because it rolls over from 23:59 to 00:00.

    Is there a way to show the total time elapsed without having the rollover effect?


    Thanks for your help

  2. #2
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Slough
    MS-Off Ver
    Excel 2007
    Posts
    469

    Re: Multiplying and Adding times to determine Elapsed time (without the rollover effect)

    Welcome to the forums.

    Well hopefully this time I have got it right!! haha If you can write the time in minutes instead of hh:mm then the below formula should work a treat for you .

    Please Login or Register  to view this content.
    ------
    Alternatively you could have 8:29 in cell F5 and then in cell F6 have the formula
    Please Login or Register  to view this content.
    Make sure that you format the cell as [h]:mm.

    Hope that helps.

    Regards

    Danny
    Last edited by DannyJ; 09-27-2012 at 11:11 AM. Reason: Got it completely wrong first time!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1