Hi Darren

Since you say you have the dates in column A and C, with Times in B and
D, and presuming the end date can never be before the start date, then
it is simply a question of creating 2 values which are both date and
time, and taking one from the other.

=(C1+D1)-(A1+B1)


--
Regards

Roger Govier


"Darren" wrote in message
...
I have 4 columns in a worksheet. Column 1 has the date, 2 has the
time, 3
has the end date and column 4 has the end time. How can I calculate
time
when the time passes the midnight in column 5? There are more than
12,000
rows and it takes forever to manually make the changes.