If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

conversion from hours to days?

Started by hrk551, 05 Apr 2010 09:17:03 AM

Previous topic - Next topic

hrk551

hello all,
Can some one help me in converting hours to days.

ex: [leaves] gives number of hours available and for suppose for epmloyee 123 there are 35 hours of leave then how should i display this [leaves] in as 4 days and 3 hrs.

Thanks

the_xxx

cast(cast(<dataitem>/1440, INTEGER), VARCHAR(10)) +
':' + cast(cast(mod(<dataitem>,1440)/60, INTEGER), VARCHAR(10)) +
':' + cast(mod(<dataitem>, 60), CHAR(2))

blom0344

cast(floor ([dataitem]/8),varchar(10))||' days '||cast(mod([dataitem],8),varchar(2))||' hours'