Time in minutes.

[JBurger]

But what JBurger is looking for sounds like he may have imported the time from some other process, and assigned it to Time2. So he will still need to parse the time into the correct format.

Bob, That is exactly what I am doing.

I used the VBS suggestion from Marcus, but I set get the string error.

Here is my script. What am I doing wrong??

Code: Select all

VBSTART
VBEND

//ASSIGN VARIABLES
Let>IFile=C:\Macros\configs\HVAC.ini

//At start of script/process get current time 
VBEval>Now(),StartTime


ReadIniFile>IFile,CONTROL,LTime,rLTime

Label>Main
VBEval>TimeValue("%rLTime%"),TimeRes


VBEval>datediff("n","%StartTime%","%TimeRes%"()),MinsElapsed

The time is just a normal time eg 9:00:00 AM

Thanks for helping
-Joe

[Bob Hansen]

Joe, can you provide an example of exactly what is being read from the INI file?

What is the vallue of rLTime ?
Is 9:00:00 AM typical of the format?

[Marcus Tettmar]

The last time should be:

VBEval>datediff("n","%StartTime%","%TimeRes%"),MinsElapsed

[Marcus Tettmar]

As the Now() function adds a date, I'd do this:

VBEval>datediff("n",TimeValue("%StartTime%"),"%TimeRes%"),MinsElapsed

Or, better:

Code: Select all

VBSTART
VBEND

//ASSIGN VARIABLES
Let>IFile=C:\Macros\configs\HVAC.ini

//At start of script/process get current time 
VBEval>Time(),StartTime

ReadIniFile>IFile,CONTROL,LTime,rLTime

Label>Main
VBEval>TimeValue("%rLTime%"),TimeRes


VBEval>datediff("n","%StartTime%","%TimeRes%"),MinsElapsed

The above use the Time() function rather than the Now() function which includes a date component. Your value from your ini file has no date component.

[Bob Hansen]

AAArgh!

Remove the extra () in the DateDiff line
-------------------------------------------------

Edited......I see that Marcus just found the same error. We are almost in sync......

[JBurger]

LOL That worked.

I looked at that line a 100 times and didn't see that.

Thanks guys!!