Thread: Calculating time difference with different formats

I would like to calculate a difference in seconds between two columns of timestamps
1. First one is "00:34:52" and formatted as "00:34:52" in Custom hh:mm:ss format.
2. Second is "12:34:55 AM" and formatted as "00:34:55" in Custom hh:mm:ss format.

I tried the recommended =TEXT(B2-A2,"ss") with different permutations in the formatting but to no avail.

Any suggestions are deeply appreciated.

you have to understand that time is indexed to 1 day
0 (zero) = 0
1 (one) = 1 day = 24 hours = 1440 minutes = 86400 seconds

If you want seconds than you need to multiply with 86400.

Set the cell format back to general as it is no longer time but a value with seconds as unit.