View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeanette
 
Posts: n/a
Default Fractional Workday Function

Say I'm adding 0.5 of a workday to April 19, 2006. Then I want to add 0.5 of
a workday again. I want the second result to be April 20, 2006. Using the
Workday function, the result is April 19th, presumably because that function
works in integers, not fractions. Can anyone offer a way to calculate
fractional workdays?
Thanks.