Extract Times

[Ballycroy]

20/03/2008 4:12:08 PM jdoe Moved to Users Hard Drive

20/03/2008 5:08:02 PM jdoe Moved to Finished Items

I have a field that has 3 paragraphs.

First paragraph is empty.

The field is not a repeating field.

How do I extract the times from each of these paragraphs and place them into 2 time fields in order to perform a total calculation.

I know I should have put this data into a separate table.

Edited June 23, 2008 by Guest

[comment]

Try

LeftWords ( GetValue ( text ; 1 ) ; [color:red]3 )

and

LeftWords ( GetValue ( text ; 2 ) ; [color:red]3 )

Edited June 23, 2008 by Guest
see below

[Fitch]

GetValue allows you select a paragraph. MiddleWords ( text ; 2 ; 2 ) can select the time. E.g.

MiddleWords ( GetValue( field; 2) ; 2 ; 2 )

Edited June 23, 2008 by Guest
Michael beat me again!

[Ballycroy]

Thanks Comment and Fitch

[comment]

Sorry, I missed the fact that your time is formatted as 12-hours AM/PM. If using LeftWords, you'll need to increase the number of words to 3.

Note that if the result is Time, you don't need to worry about the date being included.