Thanks Steve thats good for a one-off calc but I need to convert a whole column of hh.hhh to hh:mm:ss inserting the colons and hoping to not have to do it manually
Thanks for the formula help , a little more work in excel and search/replace in text and ill get there.
Glenc does your list generator have an option of outputting RA in hh:mm:ss or even hh:mm.mm ?