|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Elapsed Time Formula
Try
=IF(A2<A1,A2+1-A1,A2-A1)
"Art" wrote:
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
|