Basically I want to subtract time. The issue is with a time difference which goes on the the next day. Ex: 10/4/2006 23:30 - 10/5/2006 1:30. When I do this I use the formula, =A2+(A1-A2)-A1. This is my main question, I have the date in a different column and time in a different column. How do I concatenate both date and time to get to 10/4/2006 23:30 format. Then I can subtract times.