Thread: Difference between time in excel reported incorrectly
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Jon is offline
external usenet poster
  
Posts: 183
Default Difference between time in excel reported incorrectly
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
Reply With QuoteReply With Quote