Subtracting Times with Strang Format

[carl]

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.

 

[JE McGimpsey]

One way:

Assuming your data are in A1:A2:

A3: =A2-A1

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

 

[carl]

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

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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