As always, if you are doing a calculation it doesn't matter what format the
source cells are using to *display* the data; what does matter is that the
data values in the cells are stored as Excel's date and time. It won't work
if your input data are text strings.
--
David Biddulph

"Omar" wrote in message
oups.com...
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.