FM Bash! Posted May 31, 2006 Posted May 31, 2006 I am helping a friend and got stuck. please help. This is what I have for a total break time. I need to have 15 minutes (or .25 of an hour) to be the starting time. So, the employee is allowed 15 minutes but gets docked after this amount. I am looking for the total over 15 minutes. Round(Hour( End Break 1 - Start Break 1 ) + Minute( End Break 1 - Start Break 1 ) / 60 - Lunch fake,2)+If(End Break 1 <= Start Break 1,24,0) Thank you, Don
John Mark Osborne Posted May 31, 2006 Posted May 31, 2006 Time is stored in seconds. 900 is the number of seconds in a 15 minute increment. So, all you have to do is subtract the two break time fields and subtract 900 seconds to be left with the number of hours, minutes and/or seconds beyond their allotted break time. (End Break 1 - Start Break 1) - 900 Make sure the result of this calculation is time. I'm not sure I understand the "Lunch fake" field but hopefully I have provided enough information to complete your formula.
FM Bash! Posted June 1, 2006 Author Posted June 1, 2006 I have added -.25 to the script and this worked for displaying a negative number but I need to begin adding time after 15 minutes, or .25 has past. What do I need to change in this script to make this work? Right now this script results with a negative number until time reaches 15 minutes. I need it to be 0 (zero) until time passes 15 minute. Round(Hour( End Break 1 - Start Break 1 ) + Minute( End Break 1 - Start Break 1 ) / 60 - Lunch fake,2)+If(End Break 1 <= Start Break 1,24,0) - .25
Recommended Posts
This topic is 6812 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 accountSign in
Already have an account? Sign in here.
Sign In Now