View Single Post
 
Old 04-28-2012, 01:14 PM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question

Quote:
Originally Posted by macropod View Post
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!
The file is attached
Best
Jamal
Attached Images
File Type: jpg Clip_900.jpg (96.5 KB, 52 views)
File Type: jpg Clip_901.jpg (105.4 KB, 48 views)
File Type: jpg Clip_902.jpg (101.8 KB, 46 views)
File Type: jpg Clip_903.jpg (103.3 KB, 46 views)
Attached Files
File Type: xlsx Angles.xlsx (13.9 KB, 24 views)
Reply With Quote