Subtracting Times with Strang Format
 

My time data looks like this

2/10/2005 4:02:38 PM
2/10/2005 4:03:45 PM

Is there a formaula I can use to subtract the two times ?

Thank you in advance.

One way:

Assuming your data are in A1:A2:

A3: =A2-A1

Format A3 as Format/Cells/Number/Custom [h]:mm:ss


In article ,
"carl" wrote:

My time data looks like this

2/10/2005 4:02:38 PM
2/10/2005 4:03:45 PM

Is there a formaula I can use to subtract the two times ?

Thank you in advance.

thanks. this did not work. i think my data is uniquely formated. regards.

"carl" wrote:

My time data looks like this

2/10/2005 4:02:38 PM
2/10/2005 4:03:45 PM

Is there a formaula I can use to subtract the two times ?

Thank you in advance.

On Mon, 14 Feb 2005 08:17:02 -0800, "carl"
wrote:

My time data looks like this

2/10/2005 4:02:38 PM
2/10/2005 4:03:45 PM

Is there a formaula I can use to subtract the two times ?

Thank you in advance.

With the data in A1 and A2, the formula would be

=A2-A1

Format the result something like [h]:mm:ss


--ron

On Mon, 14 Feb 2005 09:19:04 -0800, "carl"
wrote:

thanks. this did not work. i think my data is uniquely formated. regards.

There's nothing particularly unique about your format. It is a standard Excel
format.

What does "not work" mean? Do you get a blank cell? crash Excel? some error
message? Incorrect result?

Did you enter the data manually, or import if from someplace? If you imported
or copied it from someplace, what was the source?

If your data is in A1, what is the result of the formula =ISTEXT(A1)?


--ron