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 da…

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:

Working hours calculations in Excel

Help

Luis261980 (Luis Nunes) October 11, 2019, 1:30pm 2

Hi @ Mikko_S,

read this post

3 Likes

Topic		Replies	Views
How can i get total work hours of an employee in 5 days week Help studio	1	1072	January 23, 2020
Calculation of working hours from in time and out time Help studio	7	866	January 8, 2021
Calculating Work Hour per Day Studio	2	652	February 22, 2021
Summing Working Hours in a Day StudioX	12	1686	January 1, 2021
Calculating net working days (without weekend) between two dates in Excel Help excel , activities , question	13	3466	December 11, 2020

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Working hours calculations in Excel

Related Topics