Access 2007:Calculating time elapsed based on a date 1

[Evilyvy]

Hi all,
I am new to access 2007 and I am trying to create a field in a query that will return total elapsed hours worked based on their hire date.

This returns total days:

Hours Worked: Int(DateDiff("d",[Vendors]![Hire Date],Date()))

Is there a way to format this into hours?

 

[TheAceMan1]

How are ya Evilyvy . . .

Hmmmm ... So why havn't you tried hours?

[blue]   Hours Worked: DateDiff("[purple][b]h[/b][/purple]",[Vendors]![Hire Date],Date())[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[JBinQLD]

Or assuming they haven't worked 24 hours per day:

intHoursWorked=Int(DateDiff("d",[Vendors]![Hire Date],Date()))*8

Assuming of course an 8 hour working day this will give an approximation... Depending of course on what time of day you run it

JB

 

[JBinQLD]

oh, and you may want to do something funky to discount weekends too - perhaps datediff in weeks and multiply by 16 (Hours NOT worked as it was weekend) and subtracting that from the result above...

JB

 

[MichaelRed]

there are a couple of approaches to this in FAQs. Including Work day hours, Holidays, weekends ...



MichaelRed

 

[Evilyvy]

Hey Guys,
Thanks for your help. JBinQLD your code worked perfectly! I've spent 2 days looking through all sorts of forums looking for an answer.

 

[JBinQLD]

No drama, sometimes it's easy to overlook the obvious! Good luck with your project.

JB