StartTime plus EndTime Must Equal 1 hour 1

[surfbum3000]

My tbl4Sites has various StarTimes and EndTimes. I only want to see data where the StartTime and EndTime equals one hour. Both fields are text.

 

[surfbum3000]

The time format is HH:MM.

 

[Golom]

Where DateDiff("h",timevalue([StartTime]),timevalue([EndTime])) = 1

 

[Golom]

Oh ... sorry ... Did you mean that EndTime must be 1 hour after StartTime?

Where Hour(TimeValue([StartTime])) + 1 = Hour(TimeValue([EndTime))

But note that
[tt]
StartTime 03:59
EndTime 04:01
[/tt]
will satisfy that condition even though there are only 2 minutes between those times. Perhaps you want something more elaborate

Where Minute(TimeValue([EndTime])) - Minute(TimeValue([StartTime])) BETWEEN 60 AND 119

 

[IT4EVR]

I haven't tried this out on all possibilities, but this seems to work in my testing.

WHERE DateDiff("n", [StartTime], [EndTime]) = 60

 

[surfbum3000]

This is the code that worked:

SELECT tbl4Sites.Start_Time, tbl4Sites.End_Time, DateDiff("n",[Start_Time],[End_Time])=60 AS Expr1
FROM tbl4Sites
ORDER BY tbl4Sites.Start_Time;

The results in the Expr1 field is either a 0 or -1, with -1 equaling 1 hour.