On May 3, 9:48 am, JE McGimpsey wrote:
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.- Hide quoted text -

- Show quoted text -

Dear Sir,
What should be the format of A1 and A2?
Thanks.