gruss-software.co.uk Forum Index The Ultimate Betting Exchange Software
gruss-software.co.uk
FAQ  FAQ   Search  Search   Memberlist  Memberlist   Usergroups  Usergroups
Register  ::  Log in Log in to check your private messages

gruss-software.co.uk Forum Index » Find an Excel developer » Seconds before start

Post new topic  Reply to topic
 Seconds before start « View previous topic :: View next topic » 
Author Message
sion
PostPosted: Thu Apr 12, 2012 9:47 am    Post subject: Seconds before start Reply with quote



Joined: 11 Apr 2012
Posts: 4
Does any one have the excel formula that i can insert into my sheet to place bet 30 secs before start, ive looked at the one in place_bets sheet but i cant change it to 30 secs.
Back to top
View user's profile Send private message
2020vision
PostPosted: Thu Apr 12, 2012 11:54 am    Post subject: Reply with quote

Moderator

Joined: 17 Feb 2008
Posts: 569
Location: Nottingham
Hi Smile

Put the following formula to calculate the seconds until the off in cell D2.
It shows a minus figure after the scheduled off.
Then simply use an IF statement in the trigger to fire at x or less amount of
seconds before the off that you require?

Code:
=IF(LEFT(D2)<>"-",(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2),-((HOUR(SUBSTITUTE(D2,"-",""))*3600)+(MINUTE(SUBSTITUTE(D2,"-",""))*60)+SECOND(SUBSTITUTE(D2,"-",""))))


Hope it helps - Michael Wink
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

gruss-software.co.uk Forum Index » Find an Excel developer » Seconds before start
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


DAJ Glass (1.0.8) template by Dustin Baccetti
EQ graphic based off of a design from www.freeclipart.nu
Powered by phpBB © 2001, 2005 phpBB Group