I did not consider building a (mega) formula to solve this issue a wise thing to do (but if someone does know or is able to create such a formula, please let me know), so I wrote a VBA procedure. So, if you have to calculate the hours worked when taking these conditions into account, what should you do? Should you work with functions and formulas, or should you write some VBA code? Case 05 – Start after 06:00 and End after 06:00.Case 04 – Start between 00:00 and 06:00 and End after 06:00.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |