I do a lot of work in astronomy and we use angles and time, sort of, interchangeably.
I have created custom formats which display degrees, minutes and seconds and hours, minutes, and seconds for any number
string typed into a cell.
The symbols for angles line up, naturally, as superscripts.
Can I do that with time symbols.
For example 12° 34' 45" is easy.
How about 12h 34m 45s, but with the h,m, and s as superscripts?
I attached a pic, the custom formats I'd like to
alter are in yellow.
Any help would be significantly appreciated.
P.S. My first thought was to create them as special characters in the SYMBOL dialogue box.
a lot of info on the web about this in Excel and a lot of formulae. Some quite extravagent.
I have used two formulas to convert between Degrees Minutes and Seconds and Decimal Degrees for a while.
DMS (or Hours Minutes Seconds),
The entry in cell D6 would be 89° 15' 32.77", for example, and the result 89.2591019849.
From Decimal Degrees
(or Decimal Hours) to DMS (or HMS),
The entry in cell D35 would be 2.5731869450 and the result 2h 34m 23.s473.
I also use a custom cell format to
distinguish Degrees Minutes Seconds (and Hours Minutes Seconds).
The cell format is shown in the attached pic. When entering numbers, the decimal falls after the whole seconds.
So, 89° 15' 32.77", is entered as 891532.77.