What is the format of the two times?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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.