How do I track FMLA time in excel?

G

Guest

I would like to track days/hours used of FMLA time. If someone went on Leave
Feb 24 and returned March 16, is there a way to track how many business days
or hours(considering 8 hours a day 5 days a week) were used in two cells with
a formula?
 
G

Guest

Look at function NETWORKDAYS (requires Analysis ToolPak add-in to be active).
This will give you working days.
 

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

Counting ultiple constants in cell 4
How do I change the following formula to allow for leap year 3
Excel as Attendance Tracker 8
Problem w/vlookup 5
why is answer rounded up? 1
How do I calculate time in excel (clock in and clock out 3
IF Function formula (I think?) 4
How many hours in the last 7 days did I work? 2

Top