Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas counting time
|
|
|
The UK's most regular Training information: See also: |
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Formulas counting time
Resolved · Medium Priority · Version 2007
Reply Mon 15 Aug 2011, 16:47Delegate Elina said...
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
For upcoming training course dates see: Pricing & availability
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
...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
|