How do I calculate FTE's in a monthly report if I know the total .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm making a report (grouped by month) of hours worked. I'm trying to
calculate the number of FTE's for each month. I don't know how to convert the
total hours worked into a FTE count? I guess I need to do something like:
(Total hrs worked)/(Total of work days in each month times 8 hrs).
But how do I know the number of workdays per month?
 
Do you have a table created to store holidays? Are you months actual
calendar months?
 

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

Similar Threads

Update query formula 4
Convert a percentage to an hour 2
Rounding Problem 4
Can I make a chart Report? 2
Averages are defying logic 3
Daily, Weekly, Monthly Totals 1
percentages calculated for a report 1
Access 2007-Report by Month; Year to Date Total 2

Back
Top