Sunrise/Sunset Schedule Help

[Nigel Bigelsby]

Hi all,

I have a basic question I can't seem to answer. I d/l the sunrise/sunset
schedule from the USNO and want to convert the text format into time. For
example, my cell is 711 and I want to convert it to 7:11 a.m. How do I do
that? Also, after doing that, how would I subtract an hour from it (for
daylight savings time?") Any help would be appreciated.

thanks,

 

[Peo Sjoblom]

Did you try the formula I gave you a couple of days ago?

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

for the one hour deduction

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