Thread: Total days worked /20 to get actual months/days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CINDY CINDY is offline
external usenet poster
  
Posts: 130
Default Total days worked /20 to get actual months/days
We have to report actual days worked by months/day. A work month = 20 days.
How do I take total days worked of say 76 and get the answer to show 3 months
16 days?
Reply With QuoteReply With Quote