Timeline and hours to months of the year

[mojomathers]

I have an extract from Monday.com that I would like some help with. We would like to use the xlsx output (example below) to monitor how busy people are on a monthly basis. In order to do this, the Hours should be divided across the months in the Delivery Timeline - Start and Delivery Timeline - End (see second example).

Can anyone help with how to do this?

Client	Employee	Grade	Delivery Timeline - Start	Delivery Timeline - End	Hours
ABC	Jim	Sales rep	2023-06-14	2023-08-14	30
ABC	Pam	Receptionist	2023-09-06	2023-10-06	20
ABC	Dwight	Assistant to the Regional Manager	2023-08-14	2023-08-14	30
DEF	Michael	Regional Manager	2023-08-29	2023-08-29	50
DEF	Kevin	Accounts	2023-08-01	2023-09-01	10
DEF	Andy	Sales rep	2023-08-24	2023-09-25	10

Desired output:

Client	Employee	Grade	Jun	Jul	Aug	Sep	Oct
ABC	Jim	Sales rep	10	10	10
ABC	Pam	Receptionist				10	10
ABC	Dwight	Assistant to the Regional Manager			30
DEF	Michael	Regional Manager			50
DEF	Kevin	Accounts			5	5
DEF	Andy	Sales rep			5	5

[mojomathers]

This worked. Thanks very much for your help!

[caltang]

Pleasure's all mine. Let me know what else you need help with, always a ping/message/notification away.

[mojomathers]

Well, the next challenge will be to divide not only by months, but also years. Otherwise, when we get to January it will include hours from January 2023 and also 2024 I expect!

[caltang]

Simple, just tweak the keys and months from "%B" to "%B-%Y"!

Try it yourself - that's the best way to learn.