Calculate Total Time

[Guest]

hi there,
is there any code that can calculate total time over days, weeks and years?
need help
thanks,
resti

 

[Allen Browne]

DateDiff() can cancluate one kind of thing, i.e. days, weeks, or years.

If you want something that shows the mix as a piece of text, see:
A More Complete DateDiff Function
at:
http://www.accessmvp.com/djsteele/Diff2Dates.html