Could anyone instruct me on how to make a Time sheet in Excel? I am manually adding hours but I want to create a formula that will automatically add my hours per day. Ex: In at 8:00 A.M. Out at 5:00 P.M. Total 9 Hours. Then grand total my hours for the week. I’ve tried to use the SUM formula but it won’t work. Is this even posible in excel?