Excel Guru Needed!

I need a monthly employee schedule that will show the number of hours scheduled weekly. I need an indicator for full-time and part-time employee with conditional formatting that would show if an associate was scheduled over 40-hours for a FT employee or 29 for a PT.