"14/07/2016 09:26:59" & "14/07/2016 09:28:47" I could not find difference between this time. I have enter formula =A2-A1 result shows "#VALUE!" Please help me.

  • 1
    Have you formatted the cell that contains the cell as a date/time? It sounds like it's still formatted for a general or decimal value. – Tyson Jul 26 '16 at 16:54
  • yes i have formatted still showing error – user621580 Jul 26 '16 at 17:07
  • Check format on other two cells as well, perhaps they are formatted with the wrong date/time order. I'm not near my laptop at the moment so I can't play with it – Tyson Jul 26 '16 at 17:09

Your values are text rather than true date/times. Once you converted the cells to date/times, you should see:

enter image description here

with the proper formatting for cell A3

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.