Get Hours and minutes form reload time.

[anuradhaa]

Hi I want to get hours and minutes from reload time.

[Gysbert_Wassenaar · Accepted solution]

You can create variables in the script that contain these values:

LET vHour = Hour(ReloadTime());

LET vMinutes = Minute(ReloadTime());

LET vTime = Time(Frac(ReloadTime(),'hh:mm:ss'));

Or use an expression in for example a text box: =Hour(ReloadTime()) & ' hours and ' & Minute(ReloadTime()) & ' minutes'

[swuehl]

Just take care that using above script snippet is returning the reload time of the reload time of the previous script run, not the current.

If you want to create variables that return the current reload time in the UI:

SET vHour = '=Hour(ReloadTime())';

SET vMinutes = '=Minute(ReloadTime())';

Or if you want to use the current reload time in the script itself, use Now(1):

Let vHour = Hour(Now(1));

Let vMinute = Minute(Now(1))