Find time difference

[ddmtn546]

How would one find the difference in two time fields formatted in military time within a query? Example: StartTime-StopTime. Wheresas StartTime was 17:00 & StopTime was 19:00.

 

[PaulBricker]

On the field line of a query try
MyTime:StopTime-StartTime

Depending on whether you have to account for different days, it may be all you need.

Paul

 

[Golom]

PaulBricker's solution will produce an answer in days and fractions of a day. If you want it in (for example) minutes, then

myTime: DateDiff ("n", StartTime, StopTime )

 

[PaulBricker]

Actually, if both fields are formatted Short Time, values like
19:25 - 17:35
returns 1:50
without any addtional formatting.

Paul

 

[Golom]

Good point Paul. I guess I mentally relegate formatting to being a reporting issue and don't think of it's effect on computational results.

Probably the result of a programming rather than DBMS background.

 

[PaulBricker]

Even within Access, it doesn't follow a clear pattern. It never seems the same twice when it comes to getting the format correct.

Paul