Working hours calculations in Excel

Hi,

I gotta find a way to calculate individual working hours per week. Data is in a form of attached excel file (original has 2500 rows of data) :).
I should calculate working hours per UserID in a working week monday to sunday. Work week hours should not exceed 38hours. Free days can be in any day of the week. Any suggestions what may be easiest way for filtering? I found Data Manipulations activity which may prove handy in this project.

Excel_Screenshot

Hi @ Mikko_S,

read this post

3 Likes

my suggestion is try some other tool, and save your time, there are hell lot of tools in market which are doing all this completely automated, one of the example is https://dremployee.com/time-card-calculator.php you try this tool.

I totally agree that my clients Resource Planning System should already do this job, but of course it´s not possible. We managed to tackle this with Excel VBA- scripts but solution is not elegant enough yet to post here. :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.