Thread: [Solved] the angle format (º ‘ ‘’) and calculation?
View Single Post
 
Old 04-26-2012, 06:27 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Jamal,

You could use:
=IF(C11>C9,"","-")&TEXT(ABS(C11-C9),"[hh]ºmm'ss''")
but then the contents of C12 becomes text and cannot be used as a numeric input for another formula.

As a result, you then need to change C13 to:
=IF(C11>C9,"","-")&TEXT(ABS(C11-C9)/C10,"[hh]ºmm'ss''")
and you need to change E3 to:
=C3+(C$11-C$9)/C$10

You might then also want to change the alignment in C12, C13 and D3 to D7 to right-aligned.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote