difference between two times

[dashing_peep08]

hi i have these two times that i need to subtract from each other.

login logout...
4:58PM 5:15PM
5:15PM 5:50PM
5:50PM 7:48PM
7:48PM 8:18PM
8:18PM 10:17PM
11:12PM 2:00AM
3:18AM 3:19AM

how do i get the difference between each time. logout-login.

 

[brian.wethington]

Assuming those are actual times, and your data starts in row 2

=B2 - A2

format cells according to needs.

 

[dashing_peep08]

yes thank you but its gving me a value error.

 

[dashing_peep08]

=TEXT(B2-A2,"h:mm:ss") this formula works but when the times are already changing like 11:22pm and 12:15am it already gives me a value error. but with pm to pm or am to am it works fine..

 

[cblincoln43]

try =b1-a1+(b1 < a1), will take you past the midnight hour without a date. Thanks Aladin for this formula, it has saved me manny times..

 

[dashing_peep08]

hi lincoln im still getting the value error using ur formula..

anyone please save the day for me.

thanks