You are welcome, Bruce. I'm just paying back for 31 years of this list
and its predecessors and all the list posters who taught me how to use
R:Base starting with R:Base for DOS v2.11.
Albert
On 2016-04-29 9:39 AM, Bruce Chitiea wrote:
All:
For anyone who might need it:
The topic of calculating shift time across midnight boundaries came up
in early March.
Albert Berry introduced DATETIME math, inspiring replacement of my
complicated [ Day1Hours + DaysBetween + LastDayHours ] code with:
SET VAR vDateTime_PREV = (DATETIME(.vDate_PREV , .vTime_PREV ))
SET VAR vDateTime_CURR = (DATETIME(.vDate_CURR , .vTime_CURR ))
SET VAR vElapsed_SECONDS = (.vDateTime_CURR - .vDateTime_PREV )
SET VAR vElapsed_Dec_HOURS = (ROUND((.vElapsed_SECONDS / 3600),3))
SET VAR vElapsed_Dec_DAYS = (ROUND((.vElapsed_Dec_HOURS/24),3))
SET VAR vElapsed_Cal_DAYS = (.vDate_CURR - .vDate_PREV )
Thanks again, Albert.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
