View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
TIMOTHY TIMOTHY is offline
external usenet poster
 
Posts: 45
Default Comparison of Time

Hi,

Any of you have solution to my query.

My query is every employee need to complete 45 hours a week (5*9), irrespective of whether logged in after 9 am or before 6 pm as some location employee have flexible time policy where employee can come anytime before 11 am and need to complete 9 hours

Also while calculating 45 hours per week if any Leave or outdoor would be there how we can adjust the formula as per number of days (n*9, where n €¹=5)