Excel Roster

Hi all. Have a small issue with my teams roster. Im using dropdown list with hours i.e. 8 - 5, 9 - 6, 10 - 7 etc. I would like to try to get excel to calculate hours on a weekly and monthly b...