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

2 Replies

Related Content

Project Management

Reporting on a project--12 fields

Project Condition

Multiple quote to one Project

Multiple Projects shown on GANTT Chart

Recent Discussions

Empower Next Week!

Forms help

Create Child Record, Save and then Edit button

Bug with Advanced Query in Pipelines Designer?

When the Expiration Date is On or Before Today, Change the Contract Status to Expired