This should work for you:
CalculatedTime: CStr(DateDiff("n", [StartTime], [StopTime]) \ 60) & ":" & CStr(DateDiff("n", [StartTime], [StopTime]) Mod 60)
--
John V. Ruff The Eternal Optimist :-)
Commit to the Lord whatever you do,
and your plans will succeed. Proverbs 16:3
John V. Ruff The Eternal Optimist :-)
Commit to the Lord whatever you do,
and your plans will succeed. Proverbs 16:3
-------------- Original message --------------
From: "brazilianbound" <[EMAIL PROTECTED]>
Morning!
I'm trying to get hours and minutes in my calculted field in my query
but this is giving me decimal hours.
Calculate Time: DateDiff("s",[StartTime],[StopTime])/3600
Thanks!
Clayton
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
