Dear teacher,
Please help me with Excel formula problem
for the whole format as below:
Increment for week n.1
A= Monday to Wednesday
B=Thursday to Saturday
The answer in column A1= 01 A2= 30 if the total increment for Monday to Saturday is 30. but i want auto if the is 0 increment Monday to Saturday i want the answer A1=00 B= 0.
for answer in B1= 31 B2=60 the answer in B1 should accumulate for A2 if there is increment
please help me with those problem
Best Regatds
jason ting