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
cast(cast(<dataitem>/1440, INTEGER), VARCHAR(10)) +
':' + cast(cast(mod(<dataitem>,1440)/60, INTEGER), VARCHAR(10)) +
':' + cast(mod(<dataitem>, 60), CHAR(2))
cast(floor ([dataitem]/8),varchar(10))||' days '||cast(mod([dataitem],8),varchar(2))||' hours'