View Single Post
  #1   Report Post  
kasey
 
Posts: n/a
Default How to calculate date and time

please help me in something
i have two cells:
31/10/2004 18:00
01/09/2004 07:00
i want to subtract the two cells
the result i am taking is 29/02/1900 11:00
but the correct result is 29 and one month
what can i do
thanks