Timer delay for change of sheet

[tappij2012]

Hi,

For Reloadsheet I'll use this: =left(right(Now(),2),2) as a variable.

The variable shows the seconds of the time, which are 60 seconds in a minute. So it only shows numbers from 0-59.

Sheet 1 I'll use this for example: ReloadSheet >0 and ReloadSheet <= 10 and sheet 2 for example: ReloadSheet >10 and ReloadSheet <= 20, which means that sheet 1 is visible between 1 and 10 seconds of the variable and sheet 2 between 10 and 20 seconds.

If I'll want to show 8 sheets, it's going to fast to let show each sheet.

How can I change this, so that each sheet is visible for about 30 seconds?

[stabben23 · Accepted solution]

Hi,

30 Seconds could get tricky, I have used 1 minute intervall or 2 for some sheet. Have a look.

[enriquem]

Hi, I'm awesome from your example, and i wanted to know what do you do to change the background-color of the text-Object??

Thank's

[sunny_talwar]

See if the attached works for you.

I am sure the expression can be simplified, but seems to work

[stabben23]

The text Object have different Background color on every sheet, it dont change color, but it could be fixed.

[tappij2012]

Thanks Staffan Johansson! This works for me.

[tappij2012]

Thanks for the answer! This also works fine.

[d_brown]

Unfortunately it doesn't seem to work in version 12.1 access point. Has anyone else found the same problem?