Pretty large project | just a little stuck.. there's lots of rules

Question

I'm going to shorten this as much as i can because there is way too much to show.So i'm creating a way to calculate Hours Worked/8hrs a day basicallyi just need to figure out a rule, if i get this 1st part done the rest is easy im just stuck right now.so there are 4 Fields ( ill try to show make it make more sense)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;Hour Assigned&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;Hours Clocked&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;OOA&nbsp;___________________________________________________&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; In&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Out&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;In&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Out&nbsp; &nbsp; &nbsp; 1st&nbsp; &nbsp; &nbsp; | 12:30 pm - 12:45 pm |&nbsp;12:32 pm - 12:47 pm&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp;(Should Show this, but shows 0)&nbsp;( each time is a separate Field)i have Created 4 fields Called | 1stInA&nbsp; |&nbsp; 1stOutA | 1stInB&nbsp; |1stOutBi want to make it so there difference between&nbsp;&nbsp;1stInB &amp; 1stOutB is always 15mins&nbsp;So far i only have this:( ToMinutes( [1stOutB] - [1stOutA] ) ) + ( ToMinutes( [1stInB] - [1stInA] ) )That's what i came up without the use of IF then, the problem was that it kept giving me a 0i want to make it if the time on B side is under 12:30pm (1stInB) it will count and if its above the 12:30pm (1stInB) it doesnt count and make&nbsp;12:45 pm (1stOutA) count if its over and doesnt count if its under. hopefully all of this makes sense...So if&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;Hour Assigned&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;Hours Clocked&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;OOA&nbsp;___________________________________________________&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; In&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Out&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;In&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Out&nbsp; &nbsp; &nbsp; 1st&nbsp; &nbsp; &nbsp; | 12:30 pm - 12:45 pm |&nbsp;12:25 pm - 12:40 pm&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;5i really hope there is solution to this, ill keep working on it but i really think i hit a brick wall here...&nbsp;

everettpatterso · Answer

The If statement will help, try something like thisIf([1stInB]&lt;[1stInA], ToMinutes([1stInB]-[1stInA]), ToMinutes([1stOutB]-[1stOutA]))

mikailkote · Answer

thank you :D. that was perfect.

Forum Discussion

Pretty large project | just a little stuck.. there's lots of rules

Related Content

Getting stuck on this form rule...

Is there a way to "Pause" an app

Project Names/ #s

Stuck on Embedded Report filter/setting

Project Intake Form