SharePoint 2007 :
I have a list with 2 custom columns (Creator, Checker) that contains name, date & time they respond and a third column (Duration) that is calculated field, as below:
1) Creator - domain\ledasaa 12/04/2011 12:05 --> text format
2) Checker - domain\ledasaa 13/04/2011 12:05 --> text format
3) Duration --> number format
I wanted to calculate the difference between the first 2 columns and show it in the 3rd field.
So what is the calculation? because this 2 field is text format? Please assits.. Thanks in advance
View Complete Post