Hi All,
I'm having issues with a formula calculating due to what I believe to be formatting. I've attached the actual workbook as it contains no confidential info, and it should help with context. On the "Weekly Results" tab, it keeps track of data from the days of the week tabs. There are two sections on the "Weekly Results" tab. A section for first shift, and then a section for second shift. I'm having issues with the rows labeled "Total Downtime" for each shift. The formula basically needs to subtract the total hours worked from the total load time. It won't calculate correctly because I believe it has something to do with the formatting of times. The total hours worked is just a general formatted number. The total load time row is formatted as hh:mm. It should calculate out like this: 10 hours worked, 30 minutes total load time, 9.5 hours downtime. It doesn't work that way, and I believe it is due to how Excel views time formats and that is where I am at a loss.
Bookmarks