LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Formula and worksheet will not working properly

can someone help me with a formula it is not giving me the right times. The
formula is supposed to figured the time between dates. It is not giving me
the right times. sometimes its high and sometimes its lower than what it
should be. I hope someone can help me i need this for keeping track of my
employees and questions please contact me.

The formula is
=IF(G2="","",(((NETWORKDAYS(F2,G2,$W$2:$W$22)-1)/3+MOD(G2,1)-MOD(F2,1)+((MOD(G2,1)<0.5)-(MOD(F2,1)<0.5))/48)/E2))

I can email you the sheet I am talking about it you would like. I can't
attach my sheet
 
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
formula not working properly nathanv3223 Excel Worksheet Functions 2 March 5th 09 02:16 PM
vlookup not working properly Ruth Excel Discussion (Misc queries) 5 October 28th 08 02:24 PM
Filter Not Working Properly chickalina Excel Worksheet Functions 0 April 18th 08 01:45 PM
average(if not working properly Gaurav[_2_] Excel Worksheet Functions 7 January 14th 08 07:39 PM
But not working properly Rao Ratan Singh Excel Discussion (Misc queries) 2 September 14th 06 08:45 AM


All times are GMT +1. The time now is 04:40 AM.

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

About Us

"It's about Microsoft Excel"