+ Reply to Thread
Results 1 to 6 of 6

Counting values in a time range - when the time range crosses midnight

Hybrid View

  1. 02-16-2014, 09:40 PM #1
    p24leclerc
    p24leclerc is offline
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Counting values in a time range - when the time range crosses midnight

    try the formula in the attached workbook.
    When the working hours go through midnight, you have to change the date.
    Hope this help
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.
    Reply With QuoteRegister To Reply
  2. 02-24-2014, 04:22 AM #2
    dlocos
    dlocos is offline
    Registered User
    Join Date
    06-30-2013
    Location
    Cairns, Australia
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Counting values in a time range - when the time range crosses midnight

    Thanks very much. That was most helpful and did the trick nicely
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 total time worked between a range over midnight.
    By amurr in forum Excel General
    Replies: 10
    Last Post: 03-13-2019, 03:27 AM
  2. compare time values - current time with time in cell range?
    By wyattea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2013, 11:28 PM
  3. Help with counting how many are within a time range, for a specific time
    By snswilliams in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2013, 02:19 PM
  4. Formula for Time Sheet that Crosses Midnight
    By imjuspiayin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2013, 10:24 PM
  5. Counting time ranges within a range
    By Ducatisto in forum Excel General
    Replies: 4
    Last Post: 10-17-2008, 02:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1