Skip to main content

Tech Tip: Calculate Tutor Payroll

Today a customer came with a good question.  He was trying to calculate tutor payments from a student visit report.  However, if you export the report in Excel format, you will get the Period in HH:MM format:

image

To calculate the total hours and the total payment amount, you will need to use the TIMEVALUE Excel formula.

For example, the following will return the total hours worked:

=TIMEVALUE([Cell])*24

Then you can, round that number to have only 2 decimals:

=ROUND(TIMEVALUE([Cell]) * 24, 2)

For example, if the tutor has worked for 1 hour and 30 minutes (that would be displayed as 1:30), you will get 1.50 hours using the formula above.

Or you can multiply the total hours worked (not rounded) by the hourly pay rate and then round the final amount.  If it were $20, then the final formula would be:

=ROUND(TIMEVALUE([Cell]) * 24 * 20, 2)

Being [Cell] the reference to the cell where the period is (eg, 01:30), and 20 is the hourly pay rate.

Comments

Popular posts from this blog

Referrals and Early Alert System Quick Start

I decided to write a quick step-by-step guide to start using the Referral and Early Alert System (AREAS). I hope it will help you get started with the software in just a couple minutes. In this post everything is done by hand, that means that you are going to have to type all student names, subject areas and all the information you might need. Once you have the whole thing up and running you probably will import all the other information; so I suggest you to start creating one or 2 students, one or 2 instructors, and so on. If it’s the first time you access Accudemia, maybe you went through the initial Configuration Wizard which let’s you setup the basic stuff. In this guide we will verify all the required information is there, and create it if it is not. 1. Create the Staff Accounts: It’s always a good point to start; once you have created the administrator accounts in Accudemia they can help you to setup all the other things. You can do it from the User Accounts menu. Just make su

Did you know? You can create groups from filtered reports

On reports: when you create and filter a report it "automatically" creates a User Group. After creating a report that you need, where you have filtered all of the students with " MATH "(Subject Areas), selected only the " Freshman "(Student Demographic) who have visited the center for " Tutoring "(Service Type) more than 3 times on a Visitor History report you decide you want to save that group and call them " Freshman needing Math Help ." You can do this after you run that report by visiting the User Accounts > Groups section on the left-side navigation panel. Once there simply click on the Report Generated Groups tab, then click on the report you just ran, and click edit .  At this point you can name the group and hit save changes and the group will now be available for you to use as a group filter in future reports.

Create Virtual Appointment Sessions

Just released! Watch the introductory video: Read this guide for more information