Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sunrise/Sunset Schedule Help
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sunrise/Sunset Schedule Help
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 -- Regards, Peo Sjoblom "Nigel Bigelsby" wrote in message ... 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tennis Schedule - Schedule players randomly | Excel Discussion (Misc queries) | |||
Charting Sunrise / Sunset | Charts and Charting in Excel | |||
Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
Sunrise / Sunset | Excel Worksheet Functions |