Forum Discussion

MaxKnuckleKM's avatar
MaxKnuckleKM
Copper Contributor
Jan 28, 2022

time value of money

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

excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jan 29, 2022

    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.