- Messages
- 108
- Reaction score
- 112
- Points
- 43
hi!!! i need help with October November 2009 paper 4. Instructions 4 and 5. Btw this is for CIE A2 Applied ICT. I need help! URGENT! Thank you
for step 4
write this formula to extract the first two char of the code
=left(A2,2) * A2 is just for refrence use the right location
for step 5
=IF((E2-D2)>0,E2-D2,0) it will display in 0.00069 some thing
right click the cell go to format cell select time and write in a bar hh:mm to set the format
hope it answer the question