1) First insert the shape (rectangle) then move to slicer this shape 2) Group the together and name the Group 3) then write the code worksheet ...
="Period "&IF(AND(MONTH(H4)>6,MONTH(H4)<=12),MONTH(H4)-6,IF(AND(MONTH(H4)>=1,MONTH(H4)<=6),MONTH(H4)+6,""))&" - "&YEAR(H4)-1&a...
Use this formula =(B2-A2+(B2<A2))*24*60)
Hi Irfan Try this. Hope it helps. Vasim erow = Sheets("Data").Range("F" & Rows.Count).End(xlUp).Row + 1
First to correct written the time 07:30, 00:30 like this, And use this formula =(Out time - In time+(Out time < In time))-Lunch Time
You can use =DATE((YEAR(Renewal Date)-Years),MONTH(Renewal Date),DAY(Renewal Date))
SunnyKow said Hi Vasim From my understanding, you wanted to update the cycle time and remark using the user form. You also wanted to save the old v...