Calculating time fields

[Gilbert]

Hello,

my case statement doesn't evaluate correctly. I don't know if is OK to use the Length( ) to evaluate my Justification time fields

please help!!!

Case ( Length (End Time) > 0 and Length ( S Justification time ) > 0 ; (End Time) - (S Justification time) ;

Length (End Time) > 0 and Length ( E Justification time ) > 0 ; (E Justification time) - (Start Time) ;

[color:blue]Length ( S Justification time ) > 0 and Length ( E Justification time > 0) ; (E Justification time) - (S Justification time) ;

Length (End Time) > 0 ; (End Time) - (Start Time))

[comment]

my case statement doesn't evaluate correctly

You haven't told us what the correct result should be. Based on your field names, I'd guess you want something like:

Let ( [

s = Case ( S Justification time ; S Justification time ; Start Time ) ;

e = Case ( E Justification time ; E Justification time ; End Time )

] ;

Case ( s and e ; e - s )

)

[Gilbert]

This part of the statement should calculate (E Justification time) - (S Justification time)

only if both fields: S Justification time and E Justification time have values

[Gilbert]

Now it works

Thanks for helping me

Case (S Justification time ≠ "" and E Justification time ≠ "" ; (E Justification time) - (S Justification time) ;

Length (End Time) > 0 and Length ( S Justification time ) > 0 ; (End Time) - (S Justification time) ;

Length (End Time) > 0 and Length ( E Justification time ) > 0 ; (E Justification time) - (Start Time) ;

Length (End Time) > 0 ; (End Time) - (Start Time))