View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MPI Planner[_2_] MPI Planner[_2_] is offline
external usenet poster
 
Posts: 10
Default Calculation completion date/time

I am looking at added expected production hours to a start date/time and
excluding weekends, show a completion date/time

6-Mar 10:32 PM + 12.8 "hours" =?

If I add the time to the date normally I get March 7th @ 11:21 AM. This is a
Saturday however and I want to get something on Monday. I tried using the
Workday function but only got 6-Mar 0:00 which is incorrect.