Need help with excel formulas!

%3CLINGO-SUB%20id%3D%22lingo-sub-3363347%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20one%20point%2Fhour%20per%20month%20for%20Personal%20Time%20Off%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3363347%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386363%22%20target%3D%22_blank%22%3E%40DUKETRAC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3360376%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20excel%20formulas!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3360376%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20the%20excel%20spreadsheet%20employee%20attendance.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DUKETRAC_0-1652364742535.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371182i7E3CCEC6EDBBC57B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DUKETRAC_0-1652364742535.png%22%20alt%3D%22DUKETRAC_0-1652364742535.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20am%20also%20using%20Microsoft%20Office%20version%26nbsp%3B%3CSPAN%3EVersion%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E18.2110.13110.0%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20add%20one%20hour%20per%20month%20for%20PTO%20(personal%20time%20off)%20and%20cap%20out%20at%2012%20hours.%3C%2FP%3E%3CP%3EI%20know%20the%20formula%20I%20am%20using%20isn't%20right%2C%20but%20was%20trying%20to%20make%20it%20work.%20lol%26nbsp%3B%3CBR%20%2F%3EPlus%20add%20yearly%20vacation%20time%2C%20but%20I%20would%20like%20it%20to%20begin%20on%20the%20employees%20anniversary%20day.%26nbsp%3B%20I%20am%20no%20pro%20at%20excel%2C%20but%20was%20trying%20different%20formulas.%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Employee%20Attendance%22%20href%3D%22https%3A%2F%2Fapextrailernet-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Frduke_apextrailer_net%2FETfChOaXLSlGqqMpjvE78uUBfqAPzrqriEGJIQl-bxJsvw%3Fe%3Dcdfj9k%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EEmployee%20Attendance%20Record%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20and%20all%20help%20that%20I%20can%20get.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3360376%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

I am using the excel spreadsheet employee attendance.

DUKETRAC_0-1652364742535.png

I am also using Microsoft Office version Version : 18.2110.13110.0

I am trying to add one hour per month for PTO (personal time off) and cap out at 12 hours.

I know the formula I am using isn't right, but was trying to make it work. lol 
Plus add yearly vacation time, but I would like it to begin on the employees anniversary day.  I am no pro at excel, but was trying different formulas.

Employee Attendance Record 

Thanks for any and all help that I can get.

1 Reply

@DUKETRAC 

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place.

 

Please include the following info to help others answer your question:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)