vba code

[B_Siva]

Pls help me, I need code to calculate the OT based on condition in cell $B$2 and cell A3 and cell B3.

DS & Weekday(Mon~Fri)
If outtime between 1700 to 1715 then OT = 0
If outtime between 1900 to 1915 then OT = 2

NS & Weekday(Mon~Fri)
If outtime between 400 to 415 then OT = 0
If outtime between 700 to 715 then OT = 2

NS & Weekend(sat~sun)
If outtime between 1700 to 1715 then OT = 8
If outtime between 1900 to 1915 then OT = 10
NS & Weekend(sat~sun)
If outtime between 400 to 415 then OT = 8
If outtime between 700 to 715 then OT = 10

[DonkeyOte]

Welcome to the Board, however, note:

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT on your First post then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Your thread title should relate to the underlying problem - ie "Calculating Overtime"