jonhunt wrote:

This should be easy, but I'm missing something. We have a deadline of
9:05. The actual time was 9:12. so I have 9:05 in cell B6 and I have
9:12 in cell C6. In D6 I want to show that we were 7 minutes
late...preferably that would show -7.

If I use the formula in D6 =MINUTE(c6-b6) The result is 7. Ideally I
would like fo that to be -7.

If we were actually ahead of deadline, say 9:00 a.m. the formula
returns #NUM! and I would like to show a positive number.

Hi jonhunt

To eliminate the #NUM! error:

Tools Options Calculation check 1904 date system.

Note that this will change any dates that already exist in your sheet
and you will need to amend them.

It's your sheet but if something is late, isn't it at "zero hour
+minutes" rather than zero hour -minutes"?

Regards

Steve