Results 1 to 6 of 6

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

Threaded View

dlocos Counting values in a time... 02-16-2014, 12:19 AM
p24leclerc Re: Counting values in a time... 02-16-2014, 09:40 PM
dlocos Re: Counting values in a time... 02-24-2014, 04:22 AM
bebo021999 Re: Counting values in a time... 02-16-2014, 11:44 PM
dlocos Re: Counting values in a time... 02-24-2014, 04:22 AM
vlady Re: Counting values in a time... 02-24-2014, 04:27 AM
  1. 02-16-2014, 09:40 PM #2
    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
« 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