Reputation: 100
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.
Upvotes: 1
Views: 62
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