EXCEL =(SECOND(I13)) rounding up milliseconds

[melley]

Thank you for your help with this. I'm not a developer - just a techie

I have a situation where I'm splitting a time formatted cell for calculating seconds and including milliseconds
My formula looks like this and it generally works
=(MINUTE(I15)*60)+(SECOND(I15)+(RIGHT(TEXT(I15,"mm:ss.000"),3)/1000))

And my data (time) looks like this
I15 = 01:49.833
And this field is a custom format mm:ss.000

this calculates the seconds to be
result = 110.833

but the correct answer should be
result should be = 109.833

testing has shown that it is rounding the seconds up based on the millseconds immediately following
ie 01:49.833 incorrectly becomes 110.833
while 01:49.433 correctly becomes 109.433

please help - what can I do to correct this
And the simpler the fix the better please

Cheers

 

[gaz_chops]

Welcome to the forum, try

=I15*1440*60

 

[melley]

Welcome to the forum, try

=I15*1440*60

Oh thanks man - that's golden I've been pulling my hair out
Had to be a better way - simple is always better

Thank you gaz_chops

 

[gaz_chops]

You're welcome, remember time is stored as a fraction of a day, which Excel displays in time format.