|
|
|
|
#1
01-18-2017, 04:09 PM
|
|||
|
|||
Hi Rob, You are welcome and thanks for the feedback. If you want a formula solution, this seems to work on your sample date... D2 copied to the right >> =COUNTIF($B$2:$B$431,"<"&TIME(7,0,0)+(0.0416666666 666667*(COLUMN(A1)-1)))-SUM($C$2:C2) 
|
|
| Tags |
| countif time |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Calculate Time in Hours and Percent | pabyford | Excel | 6 | 12-13-2016 12:29 PM |
 Need a formula to calculate turnaround time
|
Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
|
How do I calculate planned work for a given time period
|
bumpui | Project | 1 | 06-04-2014 06:37 AM |
| Formula to calculate Date and Time | funkyfido | Excel | 2 | 06-25-2013 04:25 PM |
|
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Windows Vista 
Office 2007
Hybrid Mode