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

formulas counting time

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas counting time

Formulas counting time

ResolvedVersion 2007

Elina has attended:
Excel Intermediate course
Excel Advanced course

Formulas counting time

I was on your Intermediate Excel 2007 course last week and wanted to learn how to create formulas for counting time. We have a spreadsheet monitoring our employees' working time but the formula doesn't seem to work correctly because even if the person works exactly 8.5 hrs 5 days a week the variation shows -0.5 which is of course wrong. How would you create such a formula? I would just like to have signing in / signing out times and then in the end of the week work out how much plus / minus the person has. Then every week I'd like to update a total variance sheet and monitor how much plus / minus each employee has. If you wish to have look at my spreadsheet (created by somebody else long time ago) I can email it to you.

Many thanks
Elina Puro

RE: Formulas counting time

Hello Elina,

Hope you enjoyed your Microsoft Intermediate course with Best STL.

Thank you for your question regarding counting time with formulas.

Yes, please email your file to me at:

rl@stl-training.co.uk

...and I will show you how to work with time values and formulas.

I look forward to your reply.

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

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.14 secs.