Ok.. here's what the deal is.

Using this formula in the template:

=IF((((D3-C3)+(F3-E3))*24)8,8,((D3-C3)+(F3-E3))*24)

If I enter the hours using military time this is what I get:

C3 D3 E3 F3 Total
8:00 11:00 12:00 18:00 8.00

If I enter the hours in this template using am/pm time this is what I get:

C3 D3 E3 F3 Total
8:00 11:00 12:00 3:00 -6.00


If I replace the formula with the one you wrote he

=MIN(8,((D3-C3)+(F3-E3))*24)

.... and use military time then I get this:

C3 D3 E3 F3 Total
8:00 11:00 12:00 3:00 TRUE

or if I use am/pm time I get this:

C3 D3 E3 F3 Total
8:00 11:00 12:00 3:00 -6.00

Here's what I want. I want to input the time in am/pm format and have the
results look like this:

C3 D3 E3 F3 Total
8:00 11:00 12:00 3:00 6.00