Special Cell Format

[Spymann]

Can anyone tell me how to format Geometric data (degrees minutes seconds) to
display and print in this format?

Thanks!

 

[JE McGimpsey]

one way:

Enter the data as time (hh:mm:ss), then use Format/Cells/Number/Custom

hh° mm' ss

 

[Spymann]

Thanks for the reply, this does exactly what I asked for, however I did not
add enough detail to my original questions so let me explain in more detail.
I have 30 individual measurements in deg min sec that I want to display as
data collect in that format as well as I want to perform statitics on that
data to perform capabilty analysis. So In summary I need to input data into
sells in the deg min sec format and perform math functions on that set of
data that outputs in the cells in deg min sec format as well. I do not have
the data collected in radians but can convert if that is the only solution.

Thanks again for your help!

 

[Spymann]

This works for the first entry in the column of data but gives erroneous
values when applied to the entire column after the first value. See below -

Input Angle Calc'd Angle
n.nnnnn hh° mm' ss
23.50000 23° 30' 00
24.25415 00° 15' 15
25.00830 01° 00' 30
25.76260 01° 45' 45
26.51675 02° 31' 00
27.27090 03° 16' 15
28.02505 04° 01' 30
28.77920 04° 46' 45
29.53335 05° 32' 00
30.28750 06° 17' 15

What am I missing here?

 

[David Biddulph]

Try [h], rather than hh, then it should avoid the problems of wrap-round
when it exceeds what it regards as 24 hours

 

[Spymann]

Hi,

I tried your suggestion of changing the format to a single "h" and got the
same output. I also tried "hhh" which also had no effect.

I am trying to display angular data as : dddo mm' ss". Excel will not accept
the " so I went to dddo mm' ss. None of these variations seem to work for
this data.

Any other ideas?

Thanks,
Spymann

Try [h], rather than hh, then it should avoid the problems of wrap-round
when it exceeds what it regards as 24 hours
--
David Biddulph

This works for the first entry in the column of data but gives erroneous
values when applied to the entire column after the first value. See
below -

Input Angle Calc'd Angle
n.nnnnn hh° mm' ss
23.50000 23° 30' 00
24.25415 00° 15' 15
25.00830 01° 00' 30
25.76260 01° 45' 45
26.51675 02° 31' 00
27.27090 03° 16' 15
28.02505 04° 01' 30
28.77920 04° 46' 45
29.53335 05° 32' 00
30.28750 06° 17' 15

What am I missing here?

 

[JE McGimpsey]

use what David actually wrote: left-bracket, h, right-bracket. The
brackets tell the display engine not to roll over at 24 hours.

I tried your suggestion of changing the format to a single "h" and got the
same output. I also tried "hhh" which also had no effect.

I am trying to display angular data as : dddo mm' ss". Excel will not accept
the " so I went to dddo mm' ss. None of these variations seem to work for
this data.

Any other ideas?

Thanks,
Spymann

Try [h], rather than hh, then it should avoid the problems of wrap-round
when it exceeds what it regards as 24 hours

 

[Spymann]

Thanks for pointing out that I over looked the "[" "]" brackets. This indeed
does make the data display as I wanted. Also thanks for explaining the
display engine interetation methodology.

Now do you have any ideas on how to get the seconds mark " to display?

Thanks again!
Spymann

use what David actually wrote: left-bracket, h, right-bracket. The
brackets tell the display engine not to roll over at 24 hours.

I tried your suggestion of changing the format to a single "h" and got the
same output. I also tried "hhh" which also had no effect.

I am trying to display angular data as : dddo mm' ss". Excel will not accept
the " so I went to dddo mm' ss. None of these variations seem to work for
this data.

Any other ideas?

Thanks,
Spymann

Try [h], rather than hh, then it should avoid the problems of wrap-round
when it exceeds what it regards as 24 hours

 

[JE McGimpsey]

Try this:

[hhh]° mm' ss\"

 

[Spymann]

Works perfectly as expected. Thanks a million!

Try this:

[hhh]° mm' ss\"

Now do you have any ideas on how to get the seconds mark " to display?