DateDiff

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
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.
 
Douglas said:
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.
Click to expand...
Excellent !!!!!!!
Works Great!

Thanks
DS
 
Back
Top