2 Replies Latest reply on Dec 13, 2016 12:42 PM by Jan Marcinek

    How to calculate working hours?

    Jan Marcinek

      Hello friends,

      I am new here I hope you will not kill me for my simple question I tried to find answer here, but nothing help me.

      I have a database with calls (in a YYYY-MM-DD HH:MM:SS format) and I need to calculate:

      1. how many calls employees made per day
      2. number of employees to answer phone calls (assume that each call takes 3 minutes)
      3. Which part of the day is more busy (morning, afternoon, night)

       

      You can find attachment