O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculating hours with a visual timesheet

When running a business, or working on projects, timesheets are a necessary component of business. As with other data, information in a pure number format is essential, albeit difficult to read at times. Creating a timesheet to represent the hours and times worked graphically, which will allow the analysis of the visual component without having to employ mathematical functions.

In this recipe, you will learn to create a visual timesheet based on the hours entered.

Getting started

This recipe will begin with a pre-formatted timesheet worksheet. Using the following example as a guide, lay out your timesheet exactly as shown. The starting time for the timesheet will be 8:00am and it will end at 20:00 or 8:00pm. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required