Guidance to Convert Degrees to Hours-minutes-seconds in EXCEL

[BharathAstro]

Hi Team,
I need your guidance to convert "0 degree 46 minutes 40 seconds" to "Hours:minutes:seconds" format in Excel.Could you please direct me to get correct solution .

Note : 1 Degree = 4 Minutes



Regards,
Bharathkumar

 

[oldbrewer]

Hi Team,
I need your guidance to convert "0 degree 46 minutes 40 seconds" to "Hours:minutes:seconds" format in Excel.Could you please direct me to get correct solution .
Note : 1 Degree = 4 Minutes
0 deg 46 min 40 sec
0.46'40"	0	46	40		split up using search
	0	46	0.666667		convert each to minutes
			46.6667		add them
			11.66668		divide by 4
			this is degrees

<colgroup><col><col span="13"></colgroup><tbody>
</tbody>