COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: adoremars on 12 Apr 2011 02:10:47 AM

Title: Timestamp diff in Hours
Post by: adoremars on 12 Apr 2011 02:10:47 AM
Hi,

I have a open date (May 15, 2007 9:21:25 AM) in this format.
And a close date (May 18, 2007 10:05:42 AM) in this format.

I need the difference in hours. ie if the diff is 45 minutes i need it in 0.45 format
and if the diff is 1 hour 45 minutes i need it in 1.45 format.

Can anyone help me to achieve this?

Thanks