Thread: Calculate current time + 7 hours and skipping weekends
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric[_2_] Eric[_2_] is offline
external usenet poster
  
Posts: 2
Default Calculate current time + 7 hours and skipping weekends
Let say is Friday at 8:00 PM. I want to add 7 hours to it and skip all
hours in Saturday and Sunday. Start adding calulating again at Monday
at 12:00 AM (Monday Morning). Any help in this would be appricated. I
have reviewed and reviewed things trying to figure this out.

Eric
Reply With QuoteReply With Quote