For Excel to be able to distinguish weekdays and weekends, you will need to put the date and time into the cells instead of just the time. If that is acceptable then I can give you a formula to do it.