time value of money

%3CLINGO-SUB%20id%3D%22lingo-sub-3083954%22%20slang%3D%22en-US%22%3Etime%20value%20of%20money%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3083954%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20a%20labor%20spreadsheet%20to%20track%20number%20of%20hours%20and%20cost%20of%20labor%20for%20each%20individual%20employee%20any%20suggestions%20for%20formulas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3083954%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085663%22%20slang%3D%22en-US%22%3ERe%3A%20time%20value%20of%20money%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1290553%22%20target%3D%22_blank%22%3E%40MaxKnuckleKM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EHere%20is%20a%20small%20approach%20with%20an%20example%20file%20-%20is%20included.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CTABLE%20width%3D%22242px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22241.2px%22%3EC2%3A%26nbsp%3B%20%3DMOD(B2-A2%2C1)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22241.2px%22%3ED2%3A%20%3DC2*24*%24F%241%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EFor%20detailed%20and%20tailor-made%20file%20on%20a%20company%2C%20upon%20request%20we%20can%20talk%20together%20about%20possibilities%20to%20help.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EHope%20this%20helped%20you%20get%20started%20with%20your%20project.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3EWas%20the%20answer%20useful%3F%3C%2FSTRONG%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23DF0000%22%3E%3CSTRONG%3E%20Mark%20them%20as%20helpful!%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%20color%3D%22%230000FF%22%3E%3CSTRONG%3EThis%20will%20help%20all%20forum%20participants.%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to create a labor spreadsheet to track number of hours and cost of labor for each individual employee any suggestions for formulas?

1 Reply

@MaxKnuckleKM 

Here is a small approach with an example file - is included.

C2:  =MOD(B2-A2,1)
D2: =C2*24*$F$1

For detailed and tailor-made file on a company, upon request we can talk together about possibilities to help.

 

Hope this helped you get started with your project.

 

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.