View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Difference between time in excel reported incorrectly

see your other post


"Jon" wrote:

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