why not just subtract end time from start time and format as [h:mm:ss]
to get hours,minutes and sec.
Or take result of subtraction and multiply by 1440 and divide by 60.
Format as general and get decimal hours.
--
JohnDK
------------------------------------------------------------------------
JohnDK's Profile:
http://www.excelforum.com/member.php...fo&userid=7184
View this thread:
http://www.excelforum.com/showthread...hreadid=482413