Excel 2007 : Formula help when entering a neg longitude (West)

Morning,

I'm using the formula provided by C. Pearson to convert degree minute seconds into degress decimal and vice versa.

The problem I am having is that when you try to convert a degree decimal longitude that is west of the meridian using a -(minus sign) back to degree minute seconds there results an error.

This is the formula for the array that needs to be able to handle a negative number:

{={1,0,0}*INT(E14)+{0,1,0}*MINUTE(E14/24)+{0,0,1}*SECOND(E14/24)}


Any ideas as to how to remedy this?

As usual any help is greatly appreciated.

George