Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dan
 
Posts: n/a
Default Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal

I would like to convert cells with degrees at 'Minutes' format. such as 43°
22', to decimal format such as 43.367.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal

see:

http://www.cpearson.com/excel/latlong.htm
--
Gary''s Student


"Dan" wrote:

I would like to convert cells with degrees at 'Minutes' format. such as 43°
22', to decimal format such as 43.367.

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
How to do I convert angles from radians to degrees in Excel? HELP ME PLEASE!!!!! Excel Worksheet Functions 2 January 13th 06 07:20 PM
adding rows of hours and minutes to get a total Tipps Excel Worksheet Functions 1 November 4th 05 07:03 PM
convert time imported as text to time format for calculations batfish Excel Worksheet Functions 3 October 27th 05 11:24 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


All times are GMT +1. The time now is 03:37 AM.

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

About Us

"It's about Microsoft Excel"