I have this formula to calculate the time difference between two dates and two times.
=(INT(V4-AB4)&" days, "&HOUR(V4-AB4)&" hours, "&MINUTE(V4-AB4)&" minutes and "&SECOND(V4-AB4)&" seconds")
they are pulling the data from these two formulas.
=TEXT(S4, "mm/dd/yyyy")&" "&TEXT(U4,"hh:mm:ss")
=TEXT(Y4, "mm/dd/yyyy")&" "&TEXT(AA4,"hh:mm:ss")
they are pulling data from two columns that i converted a number to army using this formula.
=TEXT(T4,"00\:00\:00")+0
And they are both displaying the date and time.
The thing is, is that for this example the dates are the same but the times are different and I get this error.
I used the formula on another line with two different dates and times and it works.
Any Ideas of why it is not working when the dates are the same?
Bookmarks