|
|
#2
08-26-2011, 03:45 AM
|
|||
|
|||
a simple idea is to set a blank column for users to enter extra time if needed, and complete the formula with this column
=IF(A1 <> "", A1 + TIME(2,0,0), "") =IF(A1 <> "", A1 + B1 + TIME(2,0,0), "") 
|
| Tags |
| data validation |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dependent drop down lists in Word 2007 | benbenasc | Word VBA | 0 | 08-24-2011 06:34 AM |
 How to count multiple values in a single cell, except zero?
|
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
|
Sum & difference between multiple values in a single cell
|
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
| How to create a Dependent Drop-Down Picklist | ComcoDG | Word | 2 | 03-17-2009 07:57 AM |
Windows Vista 
Office 2007
Threaded Mode