time value of money

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


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.



I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.