PDA

View Full Version : Adding Times in Excel



25-12-1998, 10:05 PM
I have an irrigation schedule which has 18 start times in one complete cycle. The duration of each start time varies within that cycle. I start the cycle at varying times each day. I have set up a simple worksheet identifying valves and their watering duration. I would like to establish a formula which adds time cumulatively(in 24 hour format)from a variable start time to show when each valve is due to open. My object is to be able to insert an irrigation start time and then have all subsequent valve opening times displayed automatically.