Do you have your terminology correct? (degree, minutes, seconds or DMS)
A degree is 1/360 of a circle, a degree is split into 60 minutes, and a
minute is split into 60 seconds. The single quote normally is for
minutes and the double quote for seconds.

As far as how you asked your question goes, Malik provided solution.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"KazFirth" wrote in message
...

I need to format a cell to show hours and minutes. For example 1'30".
How do I do this?


--
KazFirth
------------------------------------------------------------------------
KazFirth's Profile: http://www.excelforum.com/member.php...o&userid=27305
View this thread: http://www.excelforum.com/showthread...hreadid=468091