difference between 03:30:00 01/25/2007 and 05:30:00 01/27/2007
 

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.

difference between 03:30:00 01/25/2007 and 05:30:00 01/27/2007
 

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.

difference between 03:30:00 01/25/2007 and 05:30:00 01/27/2007
 

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.

difference between 03:30:00 01/25/2007 and 05:30:00 01/27/2007
 

Enter your values in A1 and A2 as a real date, then a space character, then the
time:

05/03/2007 07:21:00 AM

After you've entered the date and time, you can format the cells the way you
like:

hh:mm:ss mm/dd/yyyy
(for instance)

Omar wrote:

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.

--

Dave Peterson

difference between 03:30:00 01/25/2007 and 05:30:00 01/27/2007
 

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.