Date diff in a Query

[lakers8175]

I have two fields that I would like to find out the difference in minutes. Both fields are text. Is there a way to format the text to time and get the difference.

Time1 Time2
0255 0300

I would like the result to be 5. Because they are text fields I am having an issue.

 

[Golom]

You need to convert to DateTime and then take the difference

DateDiff("n",
    TimeSerial(Val(left(Time1,2)), Val(Right(Time1,2)),0),
    TimeSerial(Val(left(Time2,2)), Val(Right(Time2,2)),0))

 

[PHV]

Elapsed: 60*Left(Time2,2)+Right(Time2,2)-60*Left(Time1,2)-Right(Time1,2)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lakers8175]

Thanks!! Golom that did the trick. PHV thanks for the second option.