View Single Post
  #7  
Old 26-02-2007, 08:04 PM
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
You should be able to extract & mod the relevant calcs from my excel convertor for lat & long here -
http://www.iceinspace.com.au/forum/s...ad.php?t=17683


if: Cell A1 = R.A. in decimal hours

Cell A2 = Hours (only) =INT(A1)
Cell A3 = Minutes (decimal) =A1-INT(A1)*60

or if you want Hrs, Mins and Secs separated:

A3(minutes) = INT((A1-INT(A1))*60)
&
A4(seconds) = (((A1-INT(A1))*60)-A3)*60

Last edited by Gargoyle_Steve; 26-02-2007 at 08:27 PM.
Reply With Quote