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

Hi all,

I want to take weekly hours min 45 hours as per policy

ie., 5 working days * 9 hours

What would be the formula to count of non-compliance (weekly working hours is below 45 hours)