How to Calculate Business Days and Hours?

G

Guest

I have a querie that has a Start Date (MM/DD/YYYY), Start time (00:00:00),
End Date (MM/DD/YYYY) and End Time (00:00:00) Fields. I need to calculate
the amount of hours and minutes that have passed from the Start date and time
to the End data and time. I need to do this in Business Days and not
Calendar. Does anyone know how I might be able to do this?
 
S

Steve

To start you need a holidays table and maybe a business hours table.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top