I have a worksheet where I am inputting data from one sheet (Sheet2) and it copies the values to another (Sheet1). I need some help to check that the date and time have been inputted correctly and if wrong then change. so if someone entered 0800 then it would change to 08:00
Example workbook attached
thanks for looking
Bookmarks