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

hot to calculate peaks of an "irregular" sine wave 2
Calculation of peak and off peak hours 1
calculate hours using start time & end time, excluding weekends 7
measuring waves in the currency market 11
hot to calculate peaks of an "irregular" sine wave 1
Excel Catagorise AM or PM 7
Access Access - Elapsed Time between Records 5
Subtract day and time w/o weekends or holidays 2

Top