Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default calculating a formula for a service level

Thanks Mike - unfortunately it still includes the weekend days - can I
include the WEEKDAYS or NETWORKDAYS formula in this somehow? thanks

"Mike H" wrote:

Andy,

Try this:-

=IF(L2="","Open Call",L2-B2)

Format as general. It assumes L2 will always be a later date then B2 or blank.

Mike

"Andy B" wrote:

I am trying to calculate the difference between one cell and another - both
having dates in, to establish if a service level is being achieved for
completing a task.

eg. B2 = 25/6/07 and L2 = 30/6/07 (5 days)

currently if there is no date in L2, it will say "open call" - indicating
that it has not been completed.

the calculation used currently is =IF(ISERROR(DAYS360(B2,L2,TRUE)),"Open
Call",DAYS360(B2,L2,TRUE)) however this does not show working days taken to
complete the call, which is key to the measurement.

Can anybody help please?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default calculating a formula for a service level

On 1 Aug, 08:56, Andy B wrote:
Thanks Mike - unfortunately it still includes the weekend days - can I
include the WEEKDAYS or NETWORKDAYS formula in this somehow? thanks



"Mike H" wrote:
Andy,


Try this:-


=IF(L2="","Open Call",L2-B2)


Format as general. It assumes L2 will always be a later date then B2 or blank.


Mike


"Andy B" wrote:


I am trying to calculate the difference between one cell and another - both
having dates in, to establish if a service level is being achieved for
completing a task.


eg. B2 = 25/6/07 and L2 = 30/6/07 (5 days)


currently if there is no date in L2, it will say "open call" - indicating
that it has not been completed.


the calculation used currently is =IF(ISERROR(DAYS360(B2,L2,TRUE)),"Open
Call",DAYS360(B2,L2,TRUE)) however this does not show working days taken to
complete the call, which is key to the measurement.


Can anybody help please?- Hide quoted text -


- Show quoted text -


Try

=IF(L2="","Open Call",NETWORKDAYS(B2,L2))

Mike

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate SLA ( Service Level Agreement ). Thyag Excel Worksheet Functions 2 April 5th 23 01:18 PM
another EXPERT LEVEL FORMULA from me Tim Excel Discussion (Misc queries) 2 November 8th 05 12:11 PM
formula for calculating 401k if over or equal to 1 yr of service . thomas Excel Worksheet Functions 1 March 24th 05 06:43 AM
calculating service dates Tanya Excel Worksheet Functions 2 January 3rd 05 09:15 PM
Help with Years of Service formula.... Wild Bill Excel Discussion (Misc queries) 1 December 6th 04 09:47 PM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"