|
Title: Handling of time values Post by: klaus on March 03, 2010, 07:46:42 PM I need to enter data with time values and then sort based on lowest/highest.
This is for a sports race where multiple competitor will run multiple laps and each lap has a different time. I need to display which runner is in the lead lap by lap and by how much. The time will be entered by the actual time of the day (19:23:45 / hh,mm,ss). Each athlet starts in 1 minute intervals and I know ahead of time the starting order and the time cap between the runners. The grid output viewable to my website visitors needs to have the calculated time on the course after each lap. The calculation is as follows: Lap1 time minus start time = time on the course. (Start at 09:22:00 and lap1 completed at 09:28:30 equals 6minutes30seconds to complete lap1) Example: Name, lap1, lap2, lap3 , finish Runner-A , 6m30s, 12m55s, 18m34s, 24m45s Runner-B, 8m22s, 16m23s, 34m23s, 43m59s In my example Runner-A fast faster and shown ranked number (sorted above Runner-B). I have an excel sheet that does the formula exactly the way I need it but I use sigma grid for some other aspects on my site and love it. I feel SQL and dynamic content generation is the way to go on my project. My alternative if I don't get this to work with sigma grid is to contract code this to be done with other php/sql means or on a simple get the job done fast to export excel to html, lap after lap. I need this working in one week. help. |