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?