Thanks, I think i figured out, but will keep this for reference!
--- In AccessDevelopers@yahoogroups.com, [EMAIL PROTECTED] wrote:
>
> 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
>
> -------------- 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.
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
AIDS in India: A "lurking bomb." Click and help stop AIDS now.
http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
