excel - Subtracting 2 hours from a cell using VBA -
i need search column in such way if value in column "soccer", time should adjusted in column 5 2 hours (subtract 2 hours current time in column 5). format in column 5 dd/mm/yyyy hh:mm.
i struggling subtract 2 hours , replace new time vba.
any ideas?
kp
check formula, available on google.
=if(upper(a1)="soccer",e1-(2/24),"no change")
where,
- a1 column contains "soccer"
- e1 column contains "time"
Comments
Post a Comment