How can I convert a value in the form of HH:MM:SS.111 to just seconds?

Yea, it's much easier to see what you're working with and now I see why the earlier solution doesn't work for your spreadsheet

In any new column row 2 (e.g. F2), try this formula and format it as [s].000 will yield the same result as your expectation.

Formula:

=TEXT(B2,"00\:00\:00\.000")-TEXT(A2,"00\:00\:00\.000")

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Originally Posted by alvin-chung

Try this formula and format it as [s].000 will yield the same result as your expectation.

Formula:

=TEXT(B2,"00\:00\:00\.000")-TEXT(A2,"00\:00\:00\.000")

EXCELLENT! This has done exactly what I needed!

Now I need to figure out how to mark this question as solved haha

Originally Posted by alvin-chung

Try this formula and format it as [s].000 will yield the same result as your expectation.

Formula:

=TEXT(B2,"00\:00\:00\.000")-TEXT(A2,"00\:00\:00\.000")

EXCELLENT! This has done exactly what I needed!

Now I need to figure out how to mark this question as solved haha