+ Reply to Thread
Results 1 to 7 of 7

calculating over night working time

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    Dagenham essex
    MS-Off Ver
    Excel 2007
    Posts
    48

    calculating over night working time

    hi there,

    im struggling with a formula to calculate how many hours worked between 24:00 and 04:00 for shift workers.

    if a guy starts at 21:00 and finishes at 03:45 then the answer would be 3:45. if he starts at 01:00 and finishes at 06:00 then the answer would be 3:00 etc

    start time - column a
    finish time - column b
    answer column - c

    all times are entered in 24hr format

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: calculating over night working time

    =B1-A1+(B1<A1)*1
    Try this one
    I Can't under stand the Logic 06:00 - 01:00 = 3:00
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    04-17-2014
    Location
    Dagenham essex
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: calculating over night working time

    i only need to know how many hours worked between 24:00 and 04:00.

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: calculating over night working time

    =B1-A1+(B1<A1)*1
    try this

  5. #5
    Registered User
    Join Date
    04-17-2014
    Location
    Dagenham essex
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: calculating over night working time

    thank nfl sales but that only tells me total hours not what was worked between 24:00 and 04:00

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: calculating over night working time

    What is the logic? The Time Difference between 24:00 and 04:00 is 4 Hours only

  7. #7
    Registered User
    Join Date
    04-17-2014
    Location
    Dagenham essex
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: calculating over night working time

    this is a premium payment time

+ 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. Shift - Day and Night, working hours out
    By fwddesign in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-05-2016, 09:06 PM
  2. Replies: 4
    Last Post: 09-21-2012, 12:58 AM
  3. Replies: 2
    Last Post: 07-27-2012, 04:54 AM
  4. Excel 2007 : working with Day and Time and calculating
    By Kbass6319 in forum Excel General
    Replies: 2
    Last Post: 05-09-2010, 04:38 PM
  5. computing night working time
    By fatbird in forum Excel General
    Replies: 7
    Last Post: 05-02-2010, 03:26 AM

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