Difference between time in excel reported incorrectly

J

Jon

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
 
M

Mike H

Jon,

Look in your other post and tell us why you believe the difference between
these times is 5:30 when everyone else's math's indicate 7:30

Mike
 
B

Bob I

You take a two hour lunch? Then you would have to account for the
missing 2 hours in your formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel 2007 bug in difference between time 3
Copying formulas across columns 2
Calculation of time differences 4
Difference of time 3
Difference between date & time calculation 6
Difference between dates and times 5
Formatting a spreadsheet to calculate difference in dates etc. 2
How to calculate difference between two date & time along with working hours and days 2

Top