| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count of a time range
I have a list of times 0:00 - 24:00 and days and I need to find out how many
files were processed between in an 8 hour shift per day Entry Number TIME Est. Date of Arrival 9065233-5 14:56 1/1/2008 9065234-3 15:11 1/1/2008 9065235-0 15:26 1/1/2008 9065240-0 16:02 1/1/2008 7082203-1 18:30 1/1/2008 9065245-9 1:01 1/2/2008 3705209-4 1:41 1/2/2008 3705220-1 3:05 1/2/2008 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences within a time range | Excel Discussion (Misc queries) | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Excel Discussion (Misc queries) | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Threaded Mode
