sorry i am not so familiar with the angular "clock" format conversions...for
sure others may provide you good links to find what you exactly need...
then, i'll also learn from your post.
--
*****
birds of the same feather flock together..



"Spymann" wrote:

Hi,

Look at these data sets and you will see what problem I am having.

Format: Format: Format:
Number Time Custom
7 dec plcs hh:mm:ss hh° mm' ss
0.979166667 23:30:00 23° 30' 00
1.010589583 24:15:15 00° 15' 15
1.042012500 25:00:30 01° 00' 30
1.073441667 25:45:45 01° 45' 45
1.104864583 26:31:00 02° 31' 00
1.136287500 27:16:15 03° 16' 15
1.167710417 28:01:30 04° 01' 30
1.199133333 28:46:45 04° 46' 45
1.230556250 29:32:00 05° 32' 00
1.261979167 30:17:15 06° 17' 15

What I would like to display and print is data as:
ddd° mm' ss" or at least as ddd° mm' ss".

Any ideas?

Thanks,
Spymann


"driller" wrote:

can u give a collected sample of your text data format

e.g.
20 deg,20 min,20 sec
20d20m20s
20o2020€�
or whatever in order to disect your data

can u give a sample of your formula with the math function.
--
*****
birds of the same feather flock together..



"Spymann" wrote:

I have 30 individual measurements in deg min sec format that I want to
display as
data collect in that format. As well, I want to perform statitics on that
data to perform capabilty analysis. So In summary I need to input data into
cells 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.