Time elapsed calculation

[ccbarbeau]

Hi,

I have a calculated field that is the output of (time2-time1). The result looks like 71047 which means 7 hours 15 minutes and 47 seconds. I am trying to achieve a calculation field where this output would look like 7.25 hours, because I need such a format to calculate a productivity field. I've been looking everywhere and I can't seem to make this happen.

Can you please help me? I'm on RS 8.4 off of a DB2 database.

Thanks!