A timesheet app that allows employees to log time in and time out.
How we built this appThe app takes advantage of the following features: information capture via forms, app formulas, virtual columns, references, image display. [Forms] Users submit information that is immediately synced back to the owner's spreadsheet. [App Formulas] In order to calculate wages based on time worked, we converted the time values into numerical values the app can understand. -For the Total Hours column, we subtracted the time in from the time out -For the Total Wages column, we multiplied the number of hours by the hourly wage [Virtual Columns] In order for the app to be able to make the correct calculations of the above formulas, we needed to create virtual columns that run calculations but aren’t shown in the app. To do this, we needed to convert all of our time values into a decimal format. For the Number of Hours column, we used the following formulas to do this: HOUR([Total Hours]) ([Minutes]/60)+([Seconds]/3600)+[Hours] Users submit information that is immediately synced back to the owner's spreadsheet.