+ Reply to Thread
Results 1 to 7 of 7

Calculating number of hours worked in a day

  1. #1
    Registered User
    Join Date
    10-11-2007
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20806) 64-bit
    Posts
    27

    Calculating number of hours worked in a day

    I am having a problem calculating the number of hours worked in a day. I simply want to calculate the number of hours worked between cell b2 and cell c2 and place the results in cell d2 and replicate that for each row. Any help you can provide will be greatly appreciated.

    V/r

    Greg Wade
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,415

    Re: Calculating number of hours worked in a day

    In D4 copied down:

    =SUM(C4-B4)*24
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,958

    Re: Calculating number of hours worked in a day

    Try: D4=MOD(C4-B4,1)*24

  4. #4
    Registered User
    Join Date
    10-11-2007
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20806) 64-bit
    Posts
    27

    Re: Calculating number of hours worked in a day

    Thank you AliGW and josephteh. Both options worked!!!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,415

    Re: Calculating number of hours worked in a day

    Glad to have helped.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

  6. #6
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,958

    Re: Calculating number of hours worked in a day

    The MOD formula can calculate correctly if end time is less than start time, when end time crosses over to the next day.

  7. #7
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,958

    Re: Calculating number of hours worked in a day

    Thanks for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating multiple pay rates based on time of day worked, not number of hours worked
    By vdbonce in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-04-2020, 02:30 AM
  2. Replies: 8
    Last Post: 09-30-2017, 07:00 PM
  3. Calculating current number of hours worked
    By Nickolai in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2015, 07:16 PM
  4. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  5. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  6. Replies: 0
    Last Post: 01-05-2012, 06:23 AM
  7. Calculating number of hours worked for an odd shift
    By wisconsin262 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2008, 07:45 PM

Tags for this Thread

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