Deg.Min difference doesn't show minus sign

**jilaba** · 03-04-2009, 01:36 AM

1 Degree = 60 Mn
4732 is a Standard, derived from 78 deg, 52 mn (78*60+52=4732).

Input

B2= degree
C2 = Minute

Results

B3=INT((4732-((B2*60)+C2))/60)
C3=MOD(4732-((B2*60)+C2),60)

Result = B3 & C3 = 78-52 - (B2 C2)

So,

78deg 52mn - 79deg-40mn = -1 -12 (B3, C3 respectively)

But only B3 is showing "-", C3 is always "+".

What should be the right formula.

Please see the attachement, if needed.

**c_m** · 03-04-2009, 02:33 AM

see the attachment (Sheet 2).
Does it help?

**jilaba** · 03-04-2009, 11:03 AM

Sorry, doesn't help, Thanks. But i found the way, after breaking my head.

B3=IF(((B2*60)+C2)>4732,TRUNC((((B2*60)+C2)-4732)/60),-TRUNC((4732-((B2*60)+C2))/60))
C3=IF(((B2*60)+C2)>4732,(MOD((((B2*60)+C2)-4732),60)),-MOD(4732-((B2*60)+C2),60))