HI,

I am trying to write a formula that will be read how many seconds after a 15 mintue interval has lapsed.

Example. 14:02 = 120 seconds 14:49 = 240 seconds.

It will always be 00:00, 00:15, 00:30, 00:45 past the hours.

thanks in advance
Brento