View Single Post
 
Old 06-28-2011, 02:03 AM
Scaffold Scaffold is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default Using WORKDAY with fractional day lengths

Greetings everybody!

I know that this question is rather frequent, and I looked in the net for the answer, but failed to find a suitable solution. I also searched this forum, but strangely it only finds one thread from the keyword "workday". Hence the question.

Excel 2003. I have a lot of small tasks with duration well under one day - like 0.25 day. I need to calculate the duration of sequental completion of those tasks, taking weekends into account. Here's where the problems start. WORKDAY function is famous for truncating the fractional parts of the day and I am getting nowhere with such small portions of the day as mine. Any ideas how can this problem be solved?
Reply With Quote