software

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

Use a time format: 2:53 2:30 = 5:23

--
Kind regards,

Niek Otten

quot;Thodorisquot; gt; wrote in message
...
gt; Hello!
gt; Can you please advise me how can I add degrees in excel? example 2.53
gt; 2.30
gt; = 5.23
gt; Thank you in advance for your reply
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

quot;Thodorisquot; gt; wrote in message
...
gt; Hello!
gt; Can you please advise me how can I add degrees in excel? example 2.53
gt; 2.30
gt; = 5.23
gt; Thank you in advance for your reply