Question

George works in an office entering data into a computer system. He can enter the information for 25 records in 1 hour and works for 4 hours each day from Monday to Friday, starting at 09:00. The company that George works for has the option of sending George on a training course on Monday. If he goes on the course then he will not be able to enter any data that day but will be able to enter the information for 35 records each hour once he has been trained.
(a) If George goes on the training course, at what time and on which day will he have entered the same number of records as he would have done had he not gone on the course?

Answer 1

Excel gives each date a numeric value starting at 1st January 1900. ... Note: in some versions of Excel when you insert a formula it will ... The employee has to type in their time as you see it in the cell for the formatting to work correctly. ... converting them to the balance of a day (hence the 1 in the formula).