Calculate start time.

[Mantaii]

Hi!
I have a database or runners with their finish times for a race, what I need to do now is allocate a new start time for each of them.
To do this I need to subtract their finish time from 60mins. i.e. 1:00:00 - 00:30:01 = 00:29:59

How would I create a report with this information in it?

Thanks,


Owain.

[June7]

How is the time saved? Is it in a date/time datatype field or a text field?

[Mantaii]

Its stored as date/time.

[June7]

Wait, this is not the clock finish time but the total time of their run? As far as I can tell, cannot save a value like 00:30:01 in a date/time field. It would have to be 12:30:01 AM or 12:30:01 PM. Even if you set a custom format of HH:NN:SS on the field the readout will be 0:30:01.

Are you certain the field is a date/time datatype?

This actually might not be so easy. DateDiff function would require clock start and stop times, and would then calculate elapsed period. It doesn't work for what you want.

I think will have to break up the time parts, calculate total seconds, subtract from 3600 then calculate back to hh:nn:ss. Review this http://bytes.com/topic/access/answer...d-time-seconds

[Mantaii]

Hi,
I have put it in as date/time field but I guess with my times as 00:30:01, this is actually 12:30:01am ?

All I need to be able to do just now is find out who goes first in a handicapped system i.e. the slowest runner goes first with the fastest runner to go last and they all cover the distance within the 1 hour period. So the slowest runner might run the distance in 1 hour but the fastest runner in 30mins so the fastest runner doesnt start until 30mins has passed.

[June7]

Maybe something was different with 2003 but in 2010 I can't enter a time and show 00:30:01. It drops the first 0. However, doesn't change my suggestion about how to calculate.