Count Hours
Assuming your Start Date is in A1, End Date is in A2, Start Time is in B1 and End Time is in B2.
=((A2-A1)*24)+(HOUR(B2)-HOUR(B1))
© Copyright
andrewsexceltips.net
All Rights Reserved.