Difference between Work Hours and Standard Hours

[jclaborn]

Evening,

I am trying to build a production tracking tool that measures worked hours (man hours) versus standard hours.. I am having issues with J2 and P2 cell's calculating the incorrect difference in time.. Row 3 is working perfectly and doing exactly what I want it to. When there is not a date in H3 the if statement in J3 is using the =now() formula to register a date and P3 is handling it properly and calculating the hours between F3 and J3.

Its only when my employee's key in the actual completion date of the part in H2 and I2 that I have issues.. I believe its due to J2 and P2. If looking at row 2, the start date is 11/14/19 at 6AM, the end date is 11/14/19 at 8AM.. The hours that should be displayed in P2 is 2.00 representing the 2 hour difference between the times.. But I cant seem to get it to work. Column W is our work shift hours.

Be advised that column D and column H are conditionally formatted so that you can double click the cell and add the date via calendar.. Additionally, column's E and I are drop downs for the time. I have this feature to keep the formatting the same and remove typing errors. I use power query and pull down this sheet automatically which is another reason the features must remain in these columns.

Attached is the spreadsheet for reference.


Thanks,

Jason

[FDibbins]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/for-other...ard-hours.html