LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default HOW CAN I ADD DEGREES IN EXCEL?

Hi Thodoris:
Generally we can use time format for degrees since (not by chance) thee are
60 mins in 1 hour and in 1 degree of arc)
The problem is the decimal point where a colon is needed (7:28 not 7.28)
1) Use Edit | Find and Replace to convert dot to colon;
then put 60 in a blank cell, copy this, select you range of times, use
Edit|Paste Special Divide; format cells with m:ss
or
2) use a new column with (assuming first time is in A2) formula
=TIME(0,INT(A2),MOD(A2,1)*100) and format with mm:ss
or
3) use
=TIME(0,SUM(INT(A2:A4))+INT(SUM(MOD(A2:A4,1)*100)/60),MOD((SUM(MOD(A2:A4,1)*100)/60),1)*60)
entered as array formula with SHIFT+CTRL+ENTER
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Thodoris" wrote in message
...
Hello!
Can you please advise me how can I add degrees in excel? example 2.53 +
2.30
= 5.23
Thank you in advance for your 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 do i make excel calculate sines and cosines in degrees instea. inem Setting up and Configuration of Excel 1 December 3rd 05 02:00 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Value Errors with EXCEL XP not showing up in EXCEL 2000 goodguy Links and Linking in Excel 0 July 19th 05 02:38 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Allow Excel to orient/align text 180 degrees QuadJoe4x4 Excel Discussion (Misc queries) 2 January 6th 05 11:40 PM


All times are GMT +1. The time now is 10:12 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"