|
|
|
|
#1
07-18-2017, 05:38 AM
|
||||
|
||||
Of course, it would be easier if you had all your start/end times in separate cells... but you can try this in B3:
=SUMPRODUCT((MID(Sheet1!B$4:B$24,1,5)+0<=$A3)*(MID (Sheet1!B$4:B$24,FIND("-",Sheet1!B$4:B$24)+1,5)+0>=$A3))+SUMPRODUCT(( IFERROR(MID(Sheet1!B$4:B$24,13,5)+0,0)<=$A3)*( IFERROR(MID(Sheet1!B$4:B$24,19,5)+0,0)>=$A3)) you must confirm this formula with CTRL+SHIFT+ENTER not just ENTER, then copy to the right and down 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple Timesheets - id'ing two people working on the same machine at the same time. | Will | Excel | 1 | 09-28-2016 09:12 AM |
 Getting the Count formula to count all rows
|
Jennifer Murphy | Word Tables | 11 | 08-23-2016 09:37 PM |
| Count the common time period (month) between two date period of time | Barni | Excel | 6 | 08-15-2014 07:52 AM |
| How to address a letter to 10,000 different people at once. | Bit of a Trip | Word | 0 | 08-13-2010 08:44 AM |
| Meeting Invites to too many people | daisydlx | Outlook | 0 | 09-10-2009 12:21 PM |
Windows 10 
Office 2013
Hybrid Mode