98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas counting time
Formulas counting time
Resolved · Medium Priority · Version 2007
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
Tue 16 Aug 2011, 19:51Trainer Rodney said...
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
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. |
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |
