Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1310497%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1310497%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20created%20a%20spreadsheet%20that%20i%20use%20to%20record%20my%20employees%20records%20for%20payroll.%26nbsp%3B%20I%20enter%20the%20hours%20worked%20for%20the%20week%20then%20send%20a%20copy%20to%20my%20accountant%20where%20he%20documents%20the%20information.%20After%20that%20i%20delete%20the%20hours%20i%20entered%20so%20that%20it's%20once%20again%20blank%20and%20i%20can%20enter%20the%20hours%20for%20the%20next%20week.%20So%20basically%20all%20i%20do%20is%20enter%20the%20info%2C%20send%20it%20to%20my%20accountant%2C%20then%20erase%20and%20start%20over%20the%20next%20week.%20This%20works%20fine%20for%20what%20i%20need%20it%20for%20however%20i%20would%20like%20to%20be%20able%20to%20track%20the%20total%20hours%20each%20employee%20works%20per%20year.%20So%20is%20there%20a%20formula%20i%20can%20use%20to%20keep%20adding%20up%20those%20hours%20even%20if%20i%20erase%20the%20hours%20again%20after%20i%20sent%20it%20to%20my%20accountant%3F%20Basically%20it%20would%20take%20the%20sum%20of%20that%20cell%20everytime%20i%20enter%20the%20hours%20then%20retain%20the%20number%20and%20add%20it%20to%20the%20next%20total%20i%20enter%20even%20if%20the%20first%20total%20is%20no%20longer%20there.%20Anyone%20with%20ideas%20let%20me%20know.%20Thanks!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1310497%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1310542%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1310542%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F623182%22%20target%3D%22_blank%22%3E%40Leallen%3C%2FA%3E%26nbsp%3BWhy%20erase%20data%3F%20Just%20keep%20all%20your%20time%20entries%20in%20a%20long%20list.%20You%20can%20then%20filter%20out%20last%20weeks%20hours%20and%20send%20these%20to%20your%20accountant%20for%20payment.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, i created a spreadsheet that i use to record my employees records for payroll.  I enter the hours worked for the week then send a copy to my accountant where he documents the information. After that i delete the hours i entered so that it's once again blank and i can enter the hours for the next week. So basically all i do is enter the info, send it to my accountant, then erase and start over the next week. This works fine for what i need it for however i would like to be able to track the total hours each employee works per year. So is there a formula i can use to keep adding up those hours even if i erase the hours again after i sent it to my accountant? Basically it would take the sum of that cell everytime i enter the hours then retain the number and add it to the next total i enter even if the first total is no longer there. Anyone with ideas let me know. Thanks!! 

1 Reply
Highlighted

@Leallen Why erase data? Just keep all your time entries in a long list. You can then filter out last weeks hours and send these to your accountant for payment.