converting degrees into degrees, minutes and seconds

[Guest]

I have data in the format eg 179.95 I need to convert this from the decimal format into degrees, minutes and seconds
I can do this manually (0.95/100)*60 gives me the minutes value of 0.57 answer is 179 degrees 57 minutes 0 seconds
Any help with a formula would be much appreciate
Thx in advance

 

[macropod]

Hi Ajay,

For a visually correct output, simply divide the angle by 24 and apply a
custom time format:
[h]° mm' ss''
where angle is designated as hours ([h]) and a degree symbol (°) created via
Alt-0176, the mm is designated with a single tick mark ('), and the seconds
are designated with two ticks ('').

Cheers

I have data in the format eg 179.95 I need to convert this from the

decimal format into degrees, minutes and seconds.

I can do this manually (0.95/100)*60 gives me the minutes value of 0.57

answer is 179 degrees 57 minutes 0 seconds.

 

[Guest]

Excellent many thanks,
ps any advice if you have a negative angle at the moment I get ############ as the value in the cell,
negative times/ dates are displayed ####
Cheer
aja

----- macropod wrote: ----

Hi Ajay

For a visually correct output, simply divide the angle by 24 and apply
custom time format
[h]° mm' ss'
where angle is designated as hours ([h]) and a degree symbol (°) created vi
Alt-0176, the mm is designated with a single tick mark ('), and the second
are designated with two ticks ('')

Cheer

I have data in the format eg 179.95 I need to convert this from th

decimal format into degrees, minutes and seconds

I can do this manually (0.95/100)*60 gives me the minutes value of 0.5

answer is 179 degrees 57 minutes 0 seconds