Using WORKDAY with fractional day lengths

		Microsoft Office Forums > Microsoft Excel > Excel
$Using WORKDAY with fractional day lengths$ Using WORKDAY with fractional day lengths

FAQ

Thread Tools

Display Modes

06-29-2011, 12:50 AM

OTPM

$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

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

DateFinishCalculation.xls (26.5 KB, 19 views)

« Previous Thread | Next Thread »

Other Forums: Access Forums

All times are GMT -7. The time now is 11:38 AM.