View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Art is offline
external usenet poster
 
Posts: 587
Default Elapsed Time Formula

A1 22:23:54 Start Time
A2 02:15:30 End Time
A3 3:52 Elapsed Time (Hrs:Min)

I need the formula that would produce the result shown in cell A3.
(A3 is formatted in hr:mm).

Though no dates are shown, total elapsed time will never exceed about 6 hours.

Thank you .

--
Art