How much time lapsed?

[smiles112075]

What formula would I use if I want to determine how much time has lapsed between one cell and the next?

the cell is currently formatted as m/d/yyy h:mm

thanks

 

[GorD]

It should just be a matter of subtracting one cell from the other.

 

[smiles112075]

I tried that and it gives me # VAULE

10/17/2005 12:24PM #VALUE! 10/17/05 1:14PM

 

[barry houdini]

These don't look like valid formats - excel will treat these as text and hence your error, how is the time inserted - manually or by some other means?

There needs to be a space before the AM or the PM, if you insert that it should work

 

[smiles112075]

THAT WORKS GREAT ONLY ONE PROBLEM...
HOW TO I CAHNGE THE FORMAT OF THE CELL TO GET A SPACE BETWEEN THE TIME AND "AM" OR "PM"???

 

[barry houdini]

Are you manually entering times like that?

If you have times in place in that format that you want to change then use Edit > Replace and replace

A with

A [A preceded by a space]

then do the same for P