FM Bash! Posted May 31, 2006 Share 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 Link to comment Share on other sites More sharing options...
John Mark Osborne Posted May 31, 2006 Share 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. Link to comment Share on other sites More sharing options...
FM Bash! Posted June 1, 2006 Author Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6539 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