2008/6/14 JOE Conner <[EMAIL PROTECTED]>: > In Calc I would like to format a cell containing a number such as 189.25 to > display such as 180 15. > This can represent 189 and 1/4 degrees displayed as 189 minutes 15 seconds. > Such a formatting condition will be useful in displaying solutions to > navigation problems. > > I have tried tinkering with the user format cell functions - no joy. Does > anyone have a suggestion? > > Thank you. > Joe Conner, Poulsbo, WA USA >
The best I can come up with is as follows: Assume the 189.25 is in A1. 1. In B1 put the formula "=a1/24" 2. Format B1 using the user defined format "[HH] MM" I found it by fiddling with time formats but I'm not 100% sure why it works :-( Perhaps someone would be kind enough to explain - please! -- Harold Fuchs London, England Please reply *only* to [email protected]
