Currently, I have a Column G calculating the total hours for that week (a SUM formula). Column I is 40:00:00 hours. Column J is a IF formula, calculating the hours over 40. I would like to show the hours under 40, as a negative. I can figure out how to get it to calculate the correct hours under 40, but I can't get it to show as a negative, so it still appears to be "overtime" hours.

For this example, the values I have are:

H = 37:45:00

I = 40:00:00

J = 2:15:00

Current Column J formula, that only shows hours worked over 40 hours:

=IF(H87>I87, H87-I87,0)

Column J formula I'm working on that shows hours worked over or under 40, but shows both as a positive time value:

=IF(H87>I87, H87-I87, I87-H87)

I have tried different versions of multiplying I87-H87 * -1 to get it to display as a negative value, but I'm wondering if that doesn't work for time values? It just changes the cell to ##########