Start Time
Moderator: 2020vision
6 posts
• Page 1 of 1
- knot
- Posts: 196
- Joined: Sun Feb 04, 2007 9:51 pm
- Location: leicester
by phrenetic » Sun Oct 28, 2007 2:00 am
Do you mean the actual start time of the race?
Theoretically you should be able to detect when the race goes in-play - probably best from a macro - and then just record the current date & time.
I'll try to find some time later to see if I can come up with something.
Alistair
Theoretically you should be able to detect when the race goes in-play - probably best from a macro - and then just record the current date & time.
I'll try to find some time later to see if I can come up with something.
Alistair
- phrenetic
- Posts: 142
- Joined: Tue Oct 16, 2007 8:44 pm
by knot » Sun Oct 28, 2007 8:37 am
I mean if the race is due to start at 14:00 i need this in its own cell. at the moment cell A1 has all the race details, time,distance & meeting .
- knot
- Posts: 196
- Joined: Sun Feb 04, 2007 9:51 pm
- Location: leicester
- Ian
- Posts: 834
- Joined: Sat Nov 19, 2005 8:35 am
- Location: Birmingham
by knot » Sun Oct 28, 2007 9:37 am
[quote="Ian"]=TIME(MID(A1,FIND(":",A1)-2,2),MID(A1,FIND(":",A1)+1,2),0)[/quot]
Thanks Ian, i cant seem to be able to convert the time using this formula though =(V2-INT(V2))*24 if the start time is placed in cell V2.
Thanks Ian, i cant seem to be able to convert the time using this formula though =(V2-INT(V2))*24 if the start time is placed in cell V2.
- knot
- Posts: 196
- Joined: Sun Feb 04, 2007 9:51 pm
- Location: leicester
- knot
- Posts: 196
- Joined: Sun Feb 04, 2007 9:51 pm
- Location: leicester
6 posts
• Page 1 of 1
Who is online
Users browsing this forum: Bing [Bot], Google [Bot] and 54 guests