How to convert sunrise and sunset table to hours and minutes

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,
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sunrise/Sunset Schedule Help 1
How to set up sunrise and sunset timings in Outlook calender 1
Adding/subtracting time and displaying hours, minutes, seconds 2
Access Convert a decimal time to hours and minutes 2
Need help with a Formula 4
Calculate difference between hours 5
Convert Decimal Minutes to Hours-Minutes-Seconds 3
How do I add numbers to time? 1

Top