Time Keep Formula

Hi There

Hoping you can help me out with this one.

I'm trying to create a Time Keeping Register for my Company.

I have created a Unique ID card with a QR code.

I have created a spreadsheet for each Project, where they can scan the QR code onto Smartsheets with a date & time stamp. See below Screen Shot.

Now comes the hard part.

I'm looking for a formula

  • to determine the hours they worked.
  • This spreadsheet will be duplicated on other site.
    • Now I need the various spreadsheets to summarize on one sheet or report for my HR Department.

Is this possible?

Would highly appreciate you assistance.


Thank you

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!