the angle format (º ‘ ‘’) and calculation?

Jamal NUMAN · #21 04-28-2012, 01:14 PM

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!

The file is attached

Best

Jamal

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