G
GEM
I have the following,
A1=11/16/2007 11:39:00 AM
B1=11/18/2007 10:50:00 AM
How can I get C1 to give me the answer between B1-A1, a simple C1=B1-A1
won't work it gives me the anser 1/1/1900 11:11:00 PM. I want the answer to
say, 1 day 23:11 (which is the result between these two cells) and I also
want to be able to add the results from column C.
Can anyone help???
A1=11/16/2007 11:39:00 AM
B1=11/18/2007 10:50:00 AM
How can I get C1 to give me the answer between B1-A1, a simple C1=B1-A1
won't work it gives me the anser 1/1/1900 11:11:00 PM. I want the answer to
say, 1 day 23:11 (which is the result between these two cells) and I also
want to be able to add the results from column C.
Can anyone help???