If you have the Analysis ToolPak Add-in installed, you could use this
formula to round your answer as your post seems to indicate you want...

=MROUND(MOD(A2-A1,1),TIME(0,1,0))

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
You can try this formula...

=MOD(A2-A1,1)

However, when you format cell as h:mm, it won't round the 36 seconds up to
the next higher minute as your example seems to show.

--
Rick (MVP - Excel)


"Art" wrote in message
...
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