ExcelBanter - MS Excel 2007 bug in difference between time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MS Excel 2007 bug in difference between time (https://www.excelbanter.com/excel-discussion-misc-queries/214243-ms-excel-2007-bug-difference-between-time.html)

Jon

MS Excel 2007 bug in difference between time

I've created a simple worksheet to return the difference between two times,
however, the first time is being reported incorrectly by 2 hours.

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

MS Excel 2007

The result of D2 is returned as 07:30, whilst this should read 05:30. This
problem does not happen with another cell.
Am I using some incorrect formula?

Mike H

MS Excel 2007 bug in difference between time

Jon,

The difference between 2 times is a number of hours so perhaps you should be
using this.

=((C2-B2)*1440)/60

But this will return 7.5, why do you suppose it should be something different?

Mike

"Jon" wrote:

I've created a simple worksheet to return the difference between two times,
however, the first time is being reported incorrectly by 2 hours.

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

MS Excel 2007

The result of D2 is returned as 07:30, whilst this should read 05:30. This
problem does not happen with another cell.
Am I using some incorrect formula?

Chip Pearson

MS Excel 2007 bug in difference between time

According to you example data, the correct result is indeed 7:30.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Fri, 19 Dec 2008 06:01:01 -0800, Jon
wrote:

I've created a simple worksheet to return the difference between two times,
however, the first time is being reported incorrectly by 2 hours.

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

MS Excel 2007

The result of D2 is returned as 07:30, whilst this should read 05:30. This
problem does not happen with another cell.
Am I using some incorrect formula?

Bob I

MS Excel 2007 bug in difference between time

From 11 AM to 6:30 PM is 7 Hours and 30 Minutes. Or subtracting 11
hours from 18 hours and 30 minutes leaves 7 hours and 30 minutes. Please
re-examine expectations.

Jon wrote:
I've created a simple worksheet to return the difference between two times,
however, the first time is being reported incorrectly by 2 hours.

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

MS Excel 2007

The result of D2 is returned as 07:30, whilst this should read 05:30. This
problem does not happen with another cell.
Am I using some incorrect formula?

All times are GMT +1. The time now is 08:21 AM.