automatic 24h day

[Renco]

Hello,

I've got a question. I have three columns: Date, time from, and time till. Now i want when the input is for instance 7-aug from 21:00 till 3:00, excel automatically fills in the 3 hour that fall on the day after in a row below it. For example:

Input:

Date from till
7-aug 21:00 3:00

Must become:

Date from till
7-aug 21:00 24:00
8-aug 0:00 3:00

Can someone please help me how to achieve this?

[davesexcel]

Hi,
I am not sure what you are asking.
If you are wanting to add hours to a date and time this will work.
Take in mind the cell being added needs to be a true date and time, not a date and time entered as text.
Try this:
A1=8/7/08 17:15

A2 =A1+"3:00"