June 6, 200619 yr 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)
June 7, 200619 yr 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:
June 7, 200619 yr Author 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.
Create an account or sign in to comment