I've always done something in this vein... DAYS = INT(DURATION/86400) TEMP = DAYS * 86400 HOURS.SECONDS = OCONV((DURATION - TEMP),'MTHS' TOTAL.TIME = DAYS:"DAYS ":HOURS.SECONDS
oops, but you want hours, so: HOURS = INT(DURATION/3600) TEMP = HOURS * 3600 MINUTES = INT((DURATION - TEMP)/60) TOTAL.TIME = HOURS:':':MINUTES Should work... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tim Franklin Sent: Wednesday, June 06, 2007 01:09 To: [email protected] Subject: [U2] Time conversion code I have an internal time of greater than 24hrs (86400) is there a conversion code I can use to display the actual time in hours:minutes e.g. 120:45. We are running Universe 10.1.17 Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
