Dolvik
Dolvik

Reputation: 100

Incorrect calculations? Excel not performing correct time calculations

I'm simply trying to find the number of hours between the two dates and times, but excel won't account the date to the number of hours, and only calculates the 'hours' themselves.

image of excel image of excel

Upvotes: 1

Views: 62

Answers (1)

TomServo
TomServo

Reputation: 7409

Your format on cell B3 is wrong. You may have mistakenly copied the date format from the cells above to B3.

If you set your format to "General" on cell B3 and change the formula to

=ABS(B1-B2)*24

I think you'll get the result you're looking for.

Upvotes: 1

Related Questions