Receiving error when doing a simple date & time subtraction

Hi all,

I receive a "Modified On must be in the correct date and time format" when I attempt to subtract the 'created on' column from 'modified on' column. I am not sure why I am getting this error. The date format is the same for both columns. I am simply attempting to calculate the elapsed time between the two by using a basic subtraction formula, =(cell1-cell2)*1440.

Thanks!

Column C is setting with Datavalidation that only allow date >1.
You may try to get minute? then remove the datavalidation.

As bebo states the issue seems to be with the data validation rule that is applied to Table1[Column 1]
Select cell C2 and then select data validation.
Select Apply these changes to all other cells with the same settings
Select Clear All
Select OK
Now put the following formula into cell C2, set formatting to general and copy down (if auto correct options doesn't do that automatically):

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.