Jump to content

Empty if End time...


This topic is 5663 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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)

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5663 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.