469,138 Members | 1,283 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,138 developers. It's quick & easy.

Store 00:59:00 time in vb6 and access database

228 100+

I am working on a small vb6 and access project and I am totally crazy over the way time works!

There are runners and I need to store the time it took each runner to complete the race. If the athlete plays wonderfully, the committee gives him/her a bonas seconds (1-59). Then it arranges the players in order: the one who finishes first (with added seconds, if given any) comes first.

It works very fine for athletes who finish after at least one hour. But if say, the athlete finishes in 00:59:00 seconds, it doesn't work! To avoid access from changing such hours to 12..., I changed the column to text field. So, it does store it as 00:00 but when I do the math from vb 6 using dateformat, it converts it back to 12 and the athlete goes to the last of row.

My english is not good. Hope you understood me.
Oct 2 '10 #1
1 1396
Guido Geurs
767 Expert 512MB
Is it possible to store the hours, minutes and seconds in 3 different feelds and calculate the time for each athlete in seconds ?
like :
ATHLETEtime = (HOURS * 3600) + (MIN * 60 ) + SEC

How do You get Your data from Access ? is it a string like "00:00:00" ?
Then You can still isolate the Hours, minutes and seconds by SPLIT in an array and calculate the seconds for each athlete.
Oct 2 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Stuart | last post: by
2 posts views Thread by Kums | last post: by
3 posts views Thread by Mark Reed | last post: by
6 posts views Thread by Mark Reed | last post: by
2 posts views Thread by Mike Glazer | last post: by
reply views Thread by Ed Bick | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.