"Hours" and "Minutes" are just variable names. It's the calculations
that you need. If you have a textbox where you want to show the hours
and minutes, you would put something like this in its source:
=DateDiff("h",[StartTime],[StopTime]) & ":" &
DateDiff("m",[StartTime],[StopTime]) - (Hours * 60)
(Watch the word wrap here, since this will undoubtedly get wrapped
around to a second line.)
Tobi
-----Original Message-----
From: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of brazilianbound
Sent: Thursday, December 08, 2005 12:18 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Re: Caculating Time in Access Qry
It's not working it's asking for the parameters for Hours. I'm sure
it's my fault and maybe i didn't phrase my question correctly.
I need to caculate total time worked in a calculate field in my
query. Stoptime minus start time and have it format in hours &
minutes. StartTime & StopTime are in Time format in the query
already.
Clay
--- In AccessDevelopers@yahoogroups.com, "Hoffman, Tobi K \(DYS\)"
<[EMAIL PROTECTED]> wrote:
>
> Hours = DateDiff("h",[StartTime],[StopTime])
> Minutes = DateDiff("m",[StartTime],[StopTime]) - (Hours * 60)
>
> Tobi
>
> -----Original Message-----
> From: AccessDevelopers@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of
brazilianbound
> Sent: Thursday, December 08, 2005 11:21 AM
> To: AccessDevelopers@yahoogroups.com
> Subject: [AccessDevelopers] Caculating Time in Access Qry
>
>
> 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
>
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/I258zB/QnQLAA/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/
