Date & Time problem
 

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

This does it

=A1+((A2+A3/24)1)

but what happens if you have 11th Aug 06:00, length 12 in day 1. Day 2 is
still 11th Aug, but how does that previous 18 hours get accounted.

BTW, your layout was good, no apologies needed for that <g

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ckiraly" wrote in
message ...

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

Bob,

thanks. i just had to make a slight mod - =A1+((A2+A3/24)*=*1), after
that everything worked fine

thanks again

ck


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