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

's Computer Specifications

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,

's Computer Specifications

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,
>
>

's Computer Specifications

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,
> >
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate peak time	Kay Starnes	Microsoft Access Queries	5	29th Apr 2009 10:37 PM
Can I get Excel to calculate hours:minutes when sum exceeds 24?	=?Utf-8?B?bmlja3Ey?=	Microsoft Excel Worksheet Functions	5	17th May 2006 03:11 PM
how to calculate the hours and minutes in excel	=?Utf-8?B?TWl0YWw=?=	Microsoft Excel Misc	3	14th Feb 2006 06:49 PM
RE: How to Calculate Peak and Off Peak Hours	=?Utf-8?B?SmltIFRob21saW5zb24=?=	Microsoft Excel Programming	0	1st Dec 2005 12:48 AM
Excel - calculate weekdays	=?Utf-8?B?U3VlQ2hh?=	Microsoft Excel Worksheet Functions	2	18th Oct 2004 09:54 PM