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

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,

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

From 9:00 PM until when??
--
Gary''s Student - gsnu200820


"MagicBill" wrote:

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,

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

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

MagicBil

"Gary''s Student" wrote:

From 9:00 PM until when??
--
Gary''s Student - gsnu200820


"MagicBill" wrote:

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,