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

Ok, but you *didn't* enter the time a AM/PM. You *have to include (type in)
the AM/PM*. If you don't then the entry defaults to AM. So, 3:00 is being
evaluated as 3:00 AM.

.....C3..............D3..............E3........... ..F3
8:00 AM...11:00 AM...12:00 PM...3:00 PM

Don't let Excel "decide" what format it thinks you want. Format the cells
the way you want them.

Select the range of cells
Goto FormatCellsNumber tabTime
Select the 1:30 PM format
OK

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: TRUE

Hmmm....That's not possible! The formula returns a number not a boolean.

Here's a small sample file that demonstrates this:

xTime.xls 14kb

http://cjoint.com/?mngp2qsh68

It contains the formula I suggested and the one you posted. Notice that when
I entered the times I included the AM/PM.

--
Biff
Microsoft Excel MVP


"Cheryl" wrote in message
...
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