PC Review


Reply
Thread Tools Rate Thread

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

 
 
MagicBill
Guest
Posts: n/a
 
      16th Dec 2008
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,


 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      16th Dec 2008
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,
>
>

 
Reply With Quote
 
MagicBill
Guest
Posts: n/a
 
      17th Dec 2008
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,
> >
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:24 PM.