Excel

Resolved · Low Priority · Version 2007

Wed 2 Sep 2009, 12:58 Delegate Craig said...

Craig has attended:
Upgrade to Office 2007 course

Excel

How do I format a cell to count hours, in a cumulative fashion, in order to meet a minimum hours per week?

Fri 4 Sep 2009, 16:13 Trainer Amanda said...

RE: Excel

Hello Craig

Thank you for your question and welcome to the forum.

Would using the SUM function work? If the hours are entered in as numbers, e.g. you might have a series of entries 1, 2, 1, 1, 2 etc - couldn't they be added up using =sum(cell range)?

Kind regards
Amanda

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Prevent macros from running when you start Applications

Macros are automated programs that can help you speed up your work. They can be embedded in caommands like AutoExec which will make them run as soon as an application like MS Word or MS Access are launched.
Sometimes it is useful to be able to switch off this function, and then can be done by the following method.
Hold down the SHIFT key when you click on the icon to start the program. This will suppress any automated macros.

View all Microsoft Office hints and tips