I have seen some formulas regarding elapsed time calculations however, they seem to be much more complex than my needs.

My current problem is two fold:

 

1. Problem with IF statement (unavailable field)

I currently have a call start time field (defaulted Now function with date/time data type) on the Task Page layout as well as a call end time field which allows the end user to manually enter this data. What I would like to do is create an IF statement that will only enters the Now default if the subject of the task is "Call". This field resides on the task page layout. When I attempt to plug in the test segment of the IF statement however the field is not located in the available Insert merge field list and I receive the following error:

 

Field subject does not exist.  

 

2. The second part of my problem is calculating the elapsed time. I initially thought that I could simply create a field with a formula data type and subtract the call end time from the call start time however this does not work (formula return type = number). This formula is returning a decimal value as the result which is completely incorrect.

 

It would be greatly appreciated if someone could help me out!!!!!!

 

Thanks in advance :)