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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
time difference
- Thread starter kxlvba
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
If A1 contains start date, B1 contains start time, A2 contains end date and B2 contains end time:
=(INT(A2)+B2)-(INT(A1)+B1)
formatted as [hh]:mm
=(INT(A2)+B2)-(INT(A1)+B1)
formatted as [hh]:mm
Upvote
0
That's great. Now, after doing the above I'm able to concatenate date and time into the date time format, i.e. the time format. Now, if I have a situation where the start time is 10/4/2006 23:30 and the end time is 10/5/2006 1:30. In the destination cell I'm using the formula, =(INT(A2)+B2)-(INT(A1)+B1).
Upvote
0
Similar threads
