Aggregate formula

Aggregate formula

Hello!

I have two forms with following fields

EmployeeForm
  • Employee name
  • Hourly wage
TasksForm
  • Date
  • Employee name
  • Task
  • Time spent
I want to create report based on TasksForm that will summarize all the time spent by each employee and dynamically calculate employees salaries according to their hourly wage. 

Is this somehow possible? 

Thanks in advance for your help!