Results 1 to 7 of 7

Help with counting how many are within a time range, for a specific time

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Denver, Colorado, US
    MS-Off Ver
    Excel 2016
    Posts
    6

    Help with counting how many are within a time range, for a specific time

    Hello all... I am having problems getting excel to count times properly. The funny thing is I have done this before, but for some reason I am unable to get this one to work right. I have put several hours into trying to figure it out and finally decided that I should get help.

    I have attached what I am looking at and trying to work with. Basially it is a schedule and I am trying to count how many employee's I have coming in at each interval. For example, B14 is for the time durations of 0.00 - 0.29. I need B14 to count how many times the values in D56:D106 fall within B14.

    Help!!!

    Thanks!

    Steve
    Attached Files Attached Files

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