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

microsoft excel courses london - timesheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses london - Timesheets 2

microsoft excel courses london - Timesheets 2

ResolvedVersion Standard

Kristin has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course

Timesheets 2

Hi Richard,
Thanks for your response. Could you also help me as there are more calculations that I am having trouble with. I will try to explain as clearly as possible:
After the Total Hours for the Week are calculated I have to subtract it from the Standard Weekly Hours (expected). Sometimes this can be a negative, for example if someone has gone home early one day. How can I calculate negative time?
Thanks
Kristin

RE: Timesheets 2

One way to do this is to transform the resulting time to minutes.
Just add a *24*60 to the end of your calculation to change to minutes.

let me know if that works.

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel 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.