Friday, August 21, 2015

TIMEDIFFERENCE IN ACCESS



Start time 01:10:53
Stop time 01:20:05
Duration IJAM, 40MINIT

USING DATEDIFF
EXAMPLE : Minutes: DateDiff("n",[STARTTIME],[STOPTIME])

DURATION: [Minutes]\60 & Format([Minutes] Mod 60,"""JAM,  ""00""MINIT""")




No comments:

Post a Comment