|
|
#20
04-26-2012, 06:27 AM
|
||||
|
||||
Hi Jamal,
You could use: =IF(C11>C9,"","-")&TEXT(ABS(C11-C9),"[hh]ºmm'ss''") but then the contents of C12 becomes text and cannot be used as a numeric input for another formula. As a result, you then need to change C13 to: =IF(C11>C9,"","-")&TEXT(ABS(C11-C9)/C10,"[hh]ºmm'ss''") and you need to change E3 to: =C3+(C$11-C$9)/C$10 You might then also want to change the alignment in C12, C13 and D3 to D7 to right-aligned.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Date Calculation
|
Lights | Excel | 5 | 04-18-2012 04:31 AM |
| calculation of start date | ketanco | Project | 1 | 02-29-2012 07:01 AM |
|
Formula calculation
|
danbl | Excel | 8 | 02-23-2012 04:35 AM |
|
Calculation within Cells
|
manich1 | Excel | 2 | 12-07-2011 02:59 PM |
| Angle Bracket Problem, STYLEREF in Header of a Protected Document | wordjunkie | Word | 0 | 06-18-2010 04:34 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode