Time Duration w/ milliseconds

[Ocean West]

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

####:##:##

filemaker doesn't recognize milliseconds.

[comment]

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, 2010 by Guest

[Raybaudi]

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 )

)

[Raybaudi]

".0"

Why that zero ?

(there can be up to 999)

there can be up to 999999

[comment]

there can be up to 999999

Not if they are milliseconds.

[Raybaudi]

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.

[comment]

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.