Remember Me?

 nobbyknownowt Member First recorded activity by ExcelBanter: Nov 2005 Posts: 57 convert angle minute to decimal

Hi There

I want to convert an angle 1 degree 02 minutes to decimal so that i can calculate the sine of the angle.
now =1+(.02/60) gives me the answer but how do I automate it so that a 1.02 input in one cell will give me the desired 1.03 result.
Can I use the part of the input behind the decimal point and divide it? Or do i need to split the input into 2 seperate cells?

cheers
Nobby

 David Biddulph external usenet poster First recorded activity by ExcelBanter: Dec 2006 Posts: 620 convert angle minute to decimal

http://www.cpearson.com/excel/latlong.htm has info on the right way to do
it.

If you have already put the data in with the decimal point as the separator,
rather than a colon, you could use something like
=INT(A2)+(A2-INT(A2))*100/60 or
=INT(A3)+MOD(A3,1)*100/60
but you'll need to alter the formula if the angles could be negative.

Note also that it's not =1+(.02/60) as you had, but =1+(.02*100/60).
--
David Biddulph

"nobbyknownowt" wrote in message
...

Hi There

I want to convert an angle 1 degree 02 minutes to decimal so that i
can calculate the sine of the angle.
now =1+(.02/60) gives me the answer but how do I automate it so that a
1.02 input in one cell will give me the desired 1.03 result.
Can I use the part of the input behind the decimal point and divide
it? Or do i need to split the input into 2 seperate cells?

cheers
Nobby

--
nobbyknownowt

 driller2 Junior Member First recorded activity by ExcelBanter: Dec 2006 Posts: 27 if u are happy with angles considering down to the minute level [without the seconds level]
try this on
A1: type 1.02 : [this is 1 degree and 02 minutes only] : A1 must be down to 2 decimals max. only.

=INT(A1)+(A1-INT(A1))/60*100

happy holidays hohoho
pura vida romelsb Quote:
 Originally Posted by nobbyknownowt Hi There I want to convert an angle 1 degree 02 minutes to decimal so that i can calculate the sine of the angle. now =1+(.02/60) gives me the answer but how do I automate it so that a 1.02 input in one cell will give me the desired 1.03 result. Can I use the part of the input behind the decimal point and divide it? Or do i need to split the input into 2 seperate cells? cheers Nobby

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Tim Ashcom Excel Discussion (Misc queries) 5 August 17th 05 04:53 PM ramdalen Excel Discussion (Misc queries) 2 June 20th 05 06:21 PM agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM Greg T Excel Worksheet Functions 1 November 17th 04 03:07 PM Todd Excel Worksheet Functions 1 November 15th 04 06:14 PM

All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd. Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017