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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!