View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
[email protected] trvlnmny@yahoo.com is offline
external usenet poster
 
Posts: 13
Default Computing Elapsed Time

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.