AnsweredAssumed Answered

timestamp calculation

Question asked by denno on Dec 16, 2010
Latest reply on Dec 17, 2010 by bumper


timestamp calculation


I am trying to calculate the difference between 2 timestamps to find elapsed time. The initial and final fields are timestamp fields & I have a timestamp calc field that returns the difference.

An example record is:

start 11/9/2010 7:23 AM

end 11/15/2010 6:56 PM

difference 1/7/0001 11:33:00

I would like to convert the difference field into a total number of hours but can't figure out a way to do that.