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 2004 - 2010,
andrewsexceltips.net
All Rights Reserved.