Wednesday, June 12, 2013

Calculate time with excel

As a sweatshop owner, you need to keep track of the time the Smurfs, Snow White and the 7 Dwarfs and Little Red Riding Hood are working for you.
You keep a table of data containing the name of the worker, date, the start of shift time, end of shift time.
In the first column you put in the name of your worker, in the second you fill in the date (manually or my favorite way Ctrl + ; ) in the third time you fill in the time at which the worker started his shift Ctrl + Shift + ; and in the fourth column the time at which the worker finished the shift again with the same shortcut.