"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.
-
1Have 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.– TysonJul 26, 2016 at 16:54
-
yes i have formatted still showing error– user621580Jul 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– TysonJul 26, 2016 at 17:09
Add a comment
|
1 Answer
Your values are text rather than true date/times. Once you converted the cells to date/times, you should see:
with the proper formatting for cell A3