Correct again, Bob. This doesn't seem to be my best thread!

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Bob Phillips" wrote in message
...
That is not absolutely correct Niek, although a negative time is not
displayable, the value is still valid, and when included in a sum, it
works
fine.

To the OP,

I would simply do the addition in a single formula

SUMPRODUCT(--(A2:A20--"08:00:00"),(A2:A20-TIME(8,0,0)))

gives the amount of time where the cells are above 8 hours, and

=SUMPRODUCT(--(A2:A20<--"08:00:00"),--(A2:A20<""),(ABS(A2:A20-TIME(8,0,0)))
)

gives the amount of time where the cells are below 8 hours.

--
HTH

Bob Phillips

"Niek Otten" wrote in message
...
The only way you can work with negative times in Excel is to use the 1904
date system (ToolsOptions, Calculation tab).
That will change any dates you may already have in your workbook.
But you can use my formula then.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"C Tate" wrote in message
...
Bob's formula is great. The only disadvantage is that I want to be able
to
sum all these minutes over and under 8 hours and the way it is set up
won't allow me to do that!