If you have an employee who works 40 hours a week and spends 50 percent of his time on the sales floor and 50 percent of the time in the office, then that employee spends 50 percent of 40 hours ...

Excel has several custom formatting options for duration of time, and it will recognize most times you enter, provided you use a colon between the hours, minutes and seconds.