Paid Time Off Hours Formula

**Robert1960** · 06-04-2016, 08:04 AM

I'm needing help on writing a formula for Paid Time Off Hours Accrual
Please see attached work book.file:///C:/Users/Roberts/Downloads/Book1.xlsx
Hopefully this shows up this time.

**jeffreybrown** · 06-04-2016, 08:38 AM

Does this come close to what you're looking for?

**Robert1960** · 06-04-2016, 08:42 AM

yes and thanks....

**jeffreybrown** · 06-04-2016, 08:57 AM

You're very welcome...Glad it helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**Robert1960** · 06-04-2016, 09:22 AM

one more thing can you tell me how to have it stop figuring the hours once it reaches the maximum hours then start figuring again once hours have been used?

**jeffreybrown** · 06-04-2016, 10:29 AM

I'm guessing you're referring to M2.

If so, you can check for greater than of between K2 and L2.

=IF(L2>K2,"",K2-L2)

Paid Time Off Hours Formula

LinkBack

Thread Tools

Rate This Thread

Display

Paid Time Off Hours Formula

Re: Paid Time Off Hours Formula

Re: Paid Time Off Hours Formula

Re: Paid Time Off Hours Formula

Re: Paid Time Off Hours Formula

Re: Paid Time Off Hours Formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours

Formula for Timesheet - Double Time, Time Half and normal Hours

Need Sheet that Calculates/Tracks Staff Time-Off & Paid Time Off Accrual

Count workers PAID hours; colors; design problems

[SOLVED] Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week

Total hours and paid hours calculation advice

Formula for Calculating Paid Time Off for fiscal anniversary date real time

Bookmarks

Bookmarks

Posting Permissions