0

"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.

3
  • 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, 2016 at 16:54
  • yes i have formatted still showing error
    – user621580
    Jul 26, 2016 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, 2016 at 17:09

1 Answer 1

1

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .