Start time 01:10:53
Stop time 01:20:05
Duration IJAM, 40MINIT
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