David, SET VAR vTotTotalTime INT = 5052 SET VAR vTotHours INT = (.vTotTotalTime/3600) SET VAR vTotMinutes INT = ((.vTotTotalTime-(.vTotHours*3600))/60) SET VAR vTotSeconds INT = + (.vTotTotalTime-(.vTotHours*3600)-(.vTotMinutes*60) SHOW VARIABLES
Jan -----Original Message----- From: "David Fowler" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 6 Jul 2010 17:32:06 -0400 Subject: [RBASE-L] - converting real to time format Group, I'm trying to calculate elapsed time from two entries. I've got the elapsed time to calculate into a REAL number (ie. 8:00am to 10:00am shows an elapsed time in REAL format as 2.0). What I would like to be able to do is convert that REAL number to display as hours:minutes (HH:MM). Has anyone already accomplished this that is willing to share? Thanks in advance. David Fowler
