Hello,

I'm having trouble adding dates and times.
I want to be able to create a schedule based on a few inputs in the
first column: start date, start time and length. Length will also be
input manually in each column. Each column afterwards would calculate
based on the previous. The problem I'm having is the "24 hour" reset.
If the start time+length puts it into the next day, my date still stays
the same as the previous. This seems simple enough to do, but I just
can't figure it out.

My Problem:

A B C
Start date | 11 Aug 2005 | *11 Aug 2005 * |
Start time | 06:00 | 06:00 |
Length (hrs) | 24 | 24 |

Thank you very much for you help!

ck


--
ckiraly
------------------------------------------------------------------------
ckiraly's Profile: http://www.excelforum.com/member.php...o&userid=25044
View this thread: http://www.excelforum.com/showthread...hreadid=394916