DateDiff

[DS]

I'm trying to get the elapses time that a check has been opened.

DateDiff("n", [ChkTime1], Time())

I need the Hours and Minutes so I endup with this

1:22
0:35
etc.

Any help appreciated
Thanks
DS

 

[Douglas J. Steele]

DateDiff("n", [ChkTime1], Time()) \ 60 & ":" & Format(DateDiff("n",
[ChkTime1], Time()) Mod 60, "00")

Note that this will be a string: you will be unable to do any calculations
with it.

 

[DS]

DateDiff("n", [ChkTime1], Time()) \ 60 & ":" & Format(DateDiff("n",
[ChkTime1], Time()) Mod 60, "00")

Note that this will be a string: you will be unable to do any calculations
with it.

Excellent !!!!!!!
Works Great!

Thanks
DS