Date & Time problem

[ckiraly]

Hello,

I'm having trouble adding dates and times.
I want to be able to create a schedule based on a few inputs in th
first column: start date, start time and length. Length will also b
input manually in each column. Each column afterwards would calculat
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 stay
the same as the previous. This seems simple enough to do, but I jus
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!

c

 

[Bob Phillips]

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]

Bob,

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

thanks again

c