Try this but watch out if you change days, that is, go past midnight:
set var vStart time = 14:00:00
set var vEnd time = 18:00:00
set var vElapsed time = (AddSec(0:00:00, (vEnd - vStart) ))
show var vElapsed
If you are going over a date change then:
set var vStartdt datetime = '20/06/2010 14:00:00'
set var vEnddt datetime = '21/06/2010 13:00:00'
set var vElapsed time = (AddSec(0:00:00, (vEnddt - vStartdt) ))
show var vElapsed
Regards,
Alastair.
--------------------------------------------------
From: "David Fowler" <[email protected]>
Sent: Tuesday, July 06, 2010 10:32 PM
To: "RBASE-L Mailing List" <[email protected]>
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
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.830 / Virus Database: 271.1.1/2985 - Release Date: 07/06/10
07:36:00
