Thanks for the reply. I cut and pasted that in the cell then put the cell that held the number after it (B18). Excel said I should put an * befor the (B18)so I did. All I get is #VALUE! in the cell that I put the sting in. What am I doing wrong? ThanksOn 2002-09-07 17:21, Abdc wrote:
=INT(A1) & " - " & INT(60*(A1-INT(A1))) & " - " & ROUND(MOD(A1*3600,360),2)