Empty if End time...

[FM Bash!]

Help please...

I need a script statement on the end of this script that will keep the field, "Work hours", blank if the field, "End Time" is still empty.

Work hours=

Round(Hour( End Time - Start Time ) + Minute( End Time - Start Time ) / 60 - Total break time,2)+If(End Time <= Start Time,24,0)

[LaRetta]

I'm unsure why you call it a script. This can be a regular calculaton. And I'm also unsure why you break the Hours/Minutes into pieces instead of letting FileMaker handle it as one piece (which it is). But ... to answer your question try:

[color:blue]If ( End Time ;

Round(Hour( End Time - Start Time ) + Minute( End Time - Start Time ) / 60 - Total break time,2)+If(End Time <= Start Time,24,0)

[color:blue])

Wrapping it with If() which boolean tests that End Time must contain a number before it evaluates should do the trick.

LaRetta :wink2:

[FM Bash!]

Your right, this is a caculation I am looking for.

I have tried the calculation the way you wrote it, and errors come back.

One more thing: If my time card is not filled in for a previous day, the total Work Hours displays, 24, for 24 hours worked.