View Single Post
  #2   Report Post  
Wilbur Chua Wilbur Chua is offline
Member
 
Posts: 47
Default Sumif

I'm not sure if I understood your question, but I think you just need to use SUMIF Function in Excel to add the hours worked for the holiday in question.


So if you have a designated Column for Holiday or not, then you can use SUMIF to check if a certain date is a holiday. Then proceed as is.

Hope this helps!