On Monday, November 12, 2012 11:42:05 PM UTC-5, wrote:
I am working with W XP and Excel 2003.



Column A contains a start date

Column C contains an end date

The date columns are in the mm/dd/yy format

The end date will either be equal to the start date or greater than the start date



Column B contains a start time

Column D contains an end time

The time columns are in the hh:mm format and the hh portion is in 24 hour format

The end time will always be later than the start time IF the start Date and End Date are the same. If the end date is after the start date the end time can be anything.



What I need is a formula to compute the hours and minutes between the combined start date and time and the combined end date and time.



Thanks for any and all help.

Thanks for your reply.
Your solution works for those situations that occur over a short period, say 1 day.
Over a multiple day situation it is giving me a problem. The period between 10/29/12 19:33 and 11/8/12 15:40 gives me an elapsed time of 20:07.
Also when I sum up the elapsed time column I do not get a meaningful value.