Excel Guides

Calculating TV Time in Excel

You can calculate TV time in Excel by using the following formula:

=AVERAGE(F2:F16)

This formula will take the average of the TV time data that you have entered into cells F2 through F16. You can then use this average to calculate how much TV time you watch in a day, week, or month.

To calculate TV time in a day, you will need to divide the average by 24. This will give you the number of hours that you spend watching TV in a day. For example, if the average TV time is 3 hours, you will spend 3/24 = 0.125 hours watching TV in a day.

To calculate TV time in a week, you will need to multiply the average by 7. This will give you the number of hours that you spend watching TV in a week. For example, if the average TV time is 3 hours, you will spend 3 x 7 = 21 hours watching TV in a week.

To calculate TV time in a month, you will need to multiply the average by 30. This will give you the number of hours that you spend watching TV in a month. For example, if the average TV time is 3 hours, you will spend 3 x 30 = 90 hours watching TV in a month.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.