View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Computing Elapsed Time

wrote:
Column A contains a start date
Column C contains an end date

[....]
Column B contains a start time
Column D contains an end time
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.


=(C2+D2)-(A2+B2)

formatted as Custom [h]:mm .

The [h] form displays hours greater than 24, if appropriate.