Quote:
Originally Posted by macropod
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.
|
Many thanks for your creative ideas. I can’t imagine this forum without your prompt support.
In the AutoCAD, they do have the angle in DMS as data format but the calculations are much difficult to be processed there. In Excel, they don’t have the angle as data format while the calculations are a bit easier to be processed.
The data tabulated need to be further processed.
1. I need to have the cumulative error in the D column (=D3+C$13)
2. I need to add the values of D to the values of C (=C3+D3)
could you please help with this part? The issue of “negative time” requires much more workaround!