Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 21st 06, 02:57 PM
Member
 
First recorded activity by ExcelBanter: Nov 2005
Posts: 57
Default 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

  #2   Report Post  
Old December 21st 06, 06:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 620
Default 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



  #3   Report Post  
Old December 21st 06, 07:37 PM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 27
Cool

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert decimal degree (lattitude/longitude) into Degree, Tim Ashcom Excel Discussion (Misc queries) 5 August 17th 05 04:53 PM
Convert decimal hour into time format? ramdalen Excel Discussion (Misc queries) 2 June 20th 05 06:21 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
how to convert total hours (HH:MM) into decimal number Greg T Excel Worksheet Functions 1 November 17th 04 03:07 PM
convert 100 minute hour to a 60 minute hour 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