One way:

A1: 03:30:00 01/25/2007
A2: 05:30:00 01/27/2007
A3: =A2-A1

returns

50:00:00

when formatted as [hh]:mm:ss


In article .com,
Omar wrote:

Dear List,
Good morning.
Kindly, how can we get the difference between the following times?
03:30:00 01/25/2007 and 05:30:00 01/27/2007.
Thanks.