Hi,

Hoping this is a very simple question.

I need to calculate the differance between a start time and a finish time, which I have done as

=(C2-B2) for example C2 is finish time and B2 is start time

But then I need to calculate how much this is above or below 5:00 hours.

I've done this as:

=(D2-I1) for example D2 is answer to above and I1 is 5:00

This works for positive answers but negative time come up as ########

How can I work out what time differences are above and below 5 hours?

I'm doing this as a clocking in method for hours worked above or below 5 hours? (In a 24 hour clock format)

Hope this all makes sence and someone can help

OB1

Data types involved please?

If dates, then lookup DateAdd() and/or DateDiff()
If integers, check out Abs()

DateAdd and DateDiff are VBA functions, not native to Excel. So you would need the code installed and then reference the functions that way.

See DateDiff VBA

OK, i'll have a look into those function. Though i've never used VB in Excel before. I was kind of hoping i wouldnt need to get involved with VB, but if its the only way to make Excel have negative times i'll have to. Thanks, i'll let you know how i get on.

You don't need to use VBA. Excel displays "######" when a cell contains a numeric value with more digits than can be fitted into the current width. All you need to do is resize the column to see the actual answer. (My mum used to impress her boss with this all the time!)

With regard to the answer that you need, try replacing withA positive answer will mean that the time spent was that much less than five; a negative answer shows how much more than five.