I am trying to create a field to store Direction in Degrees Minutes Seconds.
I will also need to do maths with it. i.e. Criteria >= 03°15'00" .
I want to subtract a Surveyed AsBuilt Direction (BEARING) from the Designed BEARING then if it is more than the Criteria allowed, the difference in value should show up in the new (ERROR) field.
I have managed to make the other fields work. They are just normal numbers. Result shown below.
Any advice will be greatly appreciated. I will also need to limit degrees to < 180, minutes & seconds to <60.