|
|
#7
07-28-2014, 08:47 PM
|
|||
|
|||
Thanks for the work,
The time solution is more elegant (and reliable) than my effort, something to remember. The countif formula is big isn't it :-), your effort is appreciated. Do you know if there is a way to have a formula that has the ability to automatically account for new/removed shifts e.g. should a 3 hour F3 shift be added (09:00-12:00). Regards 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to count entries as per month, year and submission wise from different sheets | pinkacidpunk | Excel | 1 | 05-28-2013 08:26 AM |
| If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |
 cut&paste cell contents AND formatting
|
cglenn | Word Tables | 2 | 08-24-2011 07:04 AM |
|
How to count multiple values in a single cell, except zero?
|
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
| Copy all comments & cell contents (i.e. data) to word? | IanM | Excel | 0 | 07-03-2010 11:14 PM |
Windows Vista 
Office 2007
Threaded Mode