How can I calculate peak minutes in Excel? (< 9:00 PM, weekdays)

M

MagicBill

I am looking for a formula in Excel that will calculate peak and non-peak
cell phone minutes. Non-peak hours are after 9:00 PM and on weekends.

Thank you,
 
M

MagicBill

I believe the peak minutes start at 7 AM the following day.
I tried nested statements but it blows up on me.
Thanks!

MagicBil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

measuring waves in the currency market 11
peak units 4
Units Calculation 0
Units calculation 1
Calculation of peak and off peak hours 2
Time within time 8
Excel: counting times and dates during non-traditional hours 0
Calculation of peak / off peak hrs v2 0

Top