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!