English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

My boss said that she heard hat there is a way to make timesheets on Excel and that it will calculate the total hours for the week by itself instead of manually adding up the hours. Is this possible and if so how do you do it?

2007-07-23 08:51:32 · 3 answers · asked by vsuqt757 1 in Computers & Internet Software

3 answers

Yes.

Format the cells so they show time (FORMAT meun)
Cells can be totaled or worked on like any other math calculation.

Remember to format the cell that holds the SUM to show time too!

2007-07-23 08:57:22 · answer #1 · answered by Den B7 7 · 0 0

format the cells you want to time (crtl+1) >formating> time

2007-07-23 08:56:18 · answer #2 · answered by Anonymous · 0 0

Yes....................go with the answer from Den B7

2007-07-23 09:00:36 · answer #3 · answered by J.M.C 5 · 0 0

fedest.com, questions and answers