the angle format (º ‘ ‘’) and calculation?

		Microsoft Office Forums > Microsoft Excel > Excel
the angle format (º ‘ ‘’) and calculation?

FAQ

Thread Tools

Display Modes

04-23-2012, 04:45 AM

Catalin.B

Windows Vista

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Quote:

Actually, you can - simply input the DMS in HH:MM:SS format into a cell formatted with my custom number format. For example, for an angle of 10º15'22'', input 10:15:22. To get the decimal equivalent of that in another cell, simply multiply it by 24.

And again i bite the dust... :d

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Calculation	Lights	Excel	5	04-18-2012 04:31 AM
calculation of start date	ketanco	Project	1	02-29-2012 07:01 AM
Formula calculation	danbl	Excel	8	02-23-2012 04:35 AM
Calculation within Cells	manich1	Excel	2	12-07-2011 02:59 PM
Angle Bracket Problem, STYLEREF in Header of a Protected Document	wordjunkie	Word	0	06-18-2010 04:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:24 AM.