Need a custom function that calculates the duration of two fields that are formatted:

####:##:##

filemaker doesn't recognize milliseconds.

Assuming those are text fields, try:

GetAsTime ( Replace ( EndTime ; 9 ; 1 ; ".0" ) ) 

-

GetAsTime ( Replace ( StartTime ; 9 ; 1 ; ".0" ) ) 

---

P.S. Are you sure those are milliseconds at the end? That would be a very weird way to put them: what if there are more than 99 (there can be up to 999)? The format looks like timecode, with frames at the end.

Edited October 1, 201015 yr by Guest

filemaker doesn't recognize milliseconds.

FileMaker recognize even milliseconds, but they are a fraction of seconds.

Try:

Case(

PatternCount ( text ; ":" ) = 3 ; GetAsTime ( Replace ( text ; Position ( text ; ":" ; 1 ; 3 ) ; 1 ; Left ( 1/2 ; 1 ) ) ) ;

GetAsTime ( text )

)

".0"

Why that zero ?

(there can be up to 999)

there can be up to 999999

there can be up to 999999

Not if they are milliseconds.

Aren't they 999.999 milliseconds ?

But I was pointing on the fact that FileMaker recognize decimals of second till the sixth power, not more.

We have a context issue here: I was referring to the given format ####:##:##. If the last two digits are milliseconds, then there is a problem how to express half a second.