I also need separate formulas to convert minutes & seconds to degrees
I have attached a link below to download a sample file. What I would like is the following:
1. A formula to convert the minutes/seconds columns (yellow) to degrees. I need to add these figures to the degrees column
http://wikisend.com/download/537444/Theodolite Pre Op Check.xls
What I actually need to do is the following, convert the minutes & seconds to degrees and then add them to both the degree figures in D15 & D16 (total figure will be recorded in cell D17)
It is the total figures in E17 (Minutes) & F17 (Seconds) that I need converted to degrees. I then need to add those figures to the degree figures in cells D15 & D16.
It does not matter whether it is a combined degree result of cells E17 & F17
All entries are correct ones. The expected result for cell D17 should be 360 degrees (sum of D15, D16, E17 & F17)
The purpose of the excel file is to carry out pre-op checks of survey equipment
My apologies, I am a little confused. Can you please check the attached excel sheet and confirm that I have entered the formulas correctly. I then need to create formulas for the two cells highlighted in yellow
http://wikisend.com/download/358658/Theodolite Pre Op Check.xls
Sorry to be a pest.