Formula to add network time to leave time not working correctly

Hello,

I'm looking for a little guidance on what might be causing one of my formulas to not always calculate properly. I've attached an example workbook so you can see what I'm trying to do.

I'm adding network activity times and leave times together to determine total times per day. In column A of the 'Results by week' worksheet I've highlighted those dates that were holidays for our agency. In column N of that same sheet, I have a formula to check and see if there was a network time found in column G. If so, I wanted to determine if that time was less than or greater than 8 hours. If it was less than 8 hours, I want column N to show 8 hours; if it was more than 8 hours, I wanted the time from column G to be shown in column N. If there was no time found in column G, I wanted column N to show 8 hours.

The formula seems to be working fine, as long as there aren't any values displayed in columns H, I, or J. When there is time in both column G and H, I, or J, the formula in column N doesn't work right. Instead of showing a time, it seems to be displayed as text (although I have it formatted as a custom time). I need that time to be included in the average hours for the week, which can be seen in column O.

To be clear, this is only for those dates that are highlighted in column A. Any guidance you can provide on why my formula isn't working correctly in those instances would be greatly appreciated. Thanks.

Maybe...

=IF(AND(G31<TIME(8,0,0),G31=""),TIME(8;0,0),G31)

Glad you have found to solve the problem

Cheers