Sorry the error had timed out. I get 07:30, this should read 05:30.

"Niek Otten" wrote:

So, what do you get as a result in D2?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Jon" wrote in message
...
I'm trying to return the difference in times between two cells, however,
the
value is over by 2 hours only within one cell.

B2: 11:00
C2: 18:30
D2: =C2-B2


Is this a bug? Does anyone know of a working formula, since I only need
to
calculate the difference between times?

MS Excel 2007