How to convert sunrise and sunset table to hours and minutes

  • Thread starter Thread starter Nigel Bigelsby
  • Start date Start date
N

Nigel Bigelsby

I d/l the sunrise/sunset schedule from the USNO website and imported it into
excel. It is in text format. So 7:11 a.m. is 711. How do I get it so that it
is 7:11 a.m.? The formatting function just gives me 12:00.

Any help would be appreciated.

Thanks,
 
One way would be to use a help column, assume the values start in A1, use a
help column and this formula

=(INT(A1/100)+MOD(A1,100)/60)/24

copy down as long as needed and format as hh:mm
 
Back
Top