View Single Post
  #11  
Old 27-02-2007, 04:25 AM
Gargoyle_Steve's Avatar
Gargoyle_Steve (Steve)
Space Explorer

Gargoyle_Steve is offline
 
Join Date: Mar 2006
Location: Caloundra, Sunshine Coast, Australia
Posts: 1,571
Ken what I'd do is put Glen's original data in an Excel spreadsheet, then using his decimal RA column as the reference field add the extra cells with formula as above, then simply copy and paste downwards from there to add the formula with new reference field to each line of data .....

Ah forget it - here it is, completed


2 files - one has converted RA(decimal) to Hrs & Mins, the other converted to Hrs, Mins & Secs.

Hope you find it useful!
Attached Files
File Type: zip Glens list HrMin.zip (19.2 KB, 5 views)
File Type: zip Glens list RA in HrMinSecs.zip (22.0 KB, 7 views)

Last edited by Gargoyle_Steve; 27-02-2007 at 05:03 AM.
Reply With Quote