Time into seconds

[Stanman]

Hi,
I have a table that stores duration with milliseconds included and I then convert this into seconds for the whole duration. The issue I have is the milliseconds are not included and this puts the final value quite a bit off.
Example of value = 0:05:25.810, this is converted as 326.00. My formula is =DAY(F7114)*86400+HOUR(F7114)*3600+MINUTE(F7114)*60+SECOND(F7114), I thought the seconds would work with it but its not.

Any help would be appreciated.

 

[bebo021999]

Convert it into second, try:

=F7114*24*60*60

format as number with 2 decimal