Question

I  need word description on how and answer and also the SQL or MS useage

You are asked to look at surgeon productivity, and how well each surgeon is using their block time. For each day the surgeon works, you are given the end time of the last case of the day. How would you calculate the average end time using SQL or MS Access? Calculate based on the sample data below Please note that the scheduling systems transfers the information in text format, not date/time format. Also, results must be presented based on the 12-hour clock, not the 24-hour clock. Last Case Wheels Out 2018-07-10 16:18:00 2018-07-24 16:12:00 2018-08-14 15:48:00 2018-09-11 16:50:00 2018-10-09 15:02:00 2018-12-11 14:51:00 2018-12-18 16:34:00 2019-01-15 15:34:00 2019-01-29 17:14:00 2019-02-12 14:42:00

Answer 1

Based on the data given it will be easy to calculate the average end time

First we will take how many hours in the after that is after 12 o clock in the noon the surgeons work in the each of the data

We are just using numbers not date in the order they were presented

1. 4 hours and 18 minutes
2. 4hours 12 minutes
3. 3hours 48 minutes
4. 4hours 50 minutes
5. 3hours 2 minutes
6. 2hours 51 minutes
7. 4hours 34 minutes
8. 3hours 34 minutes
9. 5hours 14 minutes
10. 2 hours 42 minutes

So, the average will be total of the value/10 ( we know that 60minutes is one hour we add it like that)

= 2345minutes /10

= 3 hours 54 minutes and 30 seconds

So the average end time will de 3:54:30 pm , in the after noon that is just 5 minutes and 30 seconds before 4 o clock in the evening