Calculate Weekday Daytime Minutes on Cellular Worksheet

How do you calculate the weekday daytime minutes used on the cellular worksheet?

What is the sum of all the "time charged" for calls that occur on weekdays during the daytime on the calls worksheet?

Answer:

To calculate the weekday daytime minutes used on the cellular worksheet, identify calls that occur on weekdays during the daytime and sum up their time charged values.

Explanation:

To calculate the "weekday daytime minutes" used on the cellular worksheet, you will need to identify the calls that occur on weekdays during the daytime and sum up their "time charged" values. Here are the steps:

  1. Locate the calls worksheet and identify the calls that occur on weekdays during the daytime. These are the calls that have a weekday as the day and a time within the daytime hours (typically 6am to 6pm).
  2. For each of these calls, find the "time charged" value.
  3. Add up all the "time charged" values for these calls to calculate the total "weekday daytime minutes" used on the cellular worksheet.

By following these steps, you can accurately calculate the weekday daytime minutes used on the cellular worksheet.

← How to excel in data validation Unlocking future success the power of predictive analytics →