Subtracting Dates and Times

[kevsim]

In Excel 2000, I have a column with a date and another with a time, these are for the date complaint received and the time. I have another two columns one for the date and another for the time the complaint has action. What I wish to do is be able to have a further column showing the delay between receiving the complaint and the time action was taken. The data comes from another programme where I have no control.
I would appreciate your advise.
kevsim

 

[plettieri]

Hi:

Have a quick look at this earlier post...it may help

http://www.mrexcel.com/board2/viewtopic.php?t=57940&highlight=subtracting+date

plettieri

 

[kevsim]

plettieri,
Thanks for the advise, it put me on the correct path and all is working OK.
kevsim