Can anyone please help me with the following formating question?
A B C D
3/27/2007 11 49 3/27/2007 11:49

I inherited a spreadsheet that has the hour and minute columns B&C formated
as general. I tried to change the formating so I can get Column D to add
the columns. I get an incorrect date .... instead it displays 5/26/2001
0:00

A2+B2+C2 should read 3/27/2007 11:49

Thank you in advance for your time and help
Deb