Extract milliseconds, seconds and minutes from time difference value (Rounded down)

Hello,

I am having trouble with an issue regarding a time-difference value. After I calculate the difference between two timestamps, I try to convert the entire value to seconds. Then, I multiply the total number of seconds by 240 (irrelevant, but will help explain what might look erroneous in the table). In the highlighted cells, you can observe that the standard formula to convert time to seconds grossly overestimates the value. Can someone please help me extract specifically the milliseconds seconds and minutes out of the time differences observed in the lower table, so that I can manipulate them thereafter? I am especially keen on making sure the minutes/seconds values don't round up, as it would make the total number of seconds inaccurate.

Thank you!

Hi ChemistB,

After implementing your formula, it would appear my excel sheet works.
I will try a few more analyses and get right back to you.
Thank you very much.

If you mean cell C9, cell A9 is 2 minutes (120 second) 41.85 seconds, so 161.45 seconds. If what you want is seconds within minutes, you need to use

=INT(MOD(CONVERT(A9,"d","s"),60))

that is, convert the time in A1 to total seconds, then take the remainder of total seconds divided by 60, so seconds within minute, and strip off the fractional part.

More completely, see the bottommost table in the attached worksheet below.

Hi All,

Both solutions are effective. I genuinely appreciate the support.
I will mark this as solved and Add Rep.

Best Regards,
Mr. Zulu