I would like to, using a calculated field, work out the time taken in days between the field [Date Started] and [Date Completed].
I was using the example here: http://rmanimaran.wordpress.com/2011/02/11/sharepoint-tasks-list-add-a-duration-calculated-column/
=IF(OR(ISBLANK([Date Completed]),ISBLANK([Date Started])),0,FIXED([Date Completed]-[Date Started],0))
This will show whole days only but doesnt round up to 1 if the Start and End Date are the same day.
Is there an easy way to this with the code above. I can't say I'm over-clued on the subject.