Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2011, 12:50 AM
OTPM OTPM is offline Using WORKDAY with fractional day lengths Windows 7 32bit Using WORKDAY with fractional day lengths Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Scaffold
Please see attached.
This is the closest I can get to exclude weekends but we need to find a way of checking entries that are moved to the next working day to see if the total working hours are greater than 8.
Colin may be able to help on this.
Good luck.
Tony(OTPM)
Attached Files
File Type: xls DateFinishCalculation.xls (26.5 KB, 19 views)
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2026 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft