Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

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?

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

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Microsoft Office tip:

Copying From Websites

If you find some interesting text on a website that you wish to use and adapt in your wordprocessor or other package, highlight and copy in the normal way first.

When you paste though, use the Paste Special option to insert as unformatted text. That cuts out all the fancy formatting and hyperlinks that may be embedded.

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.