Calculate minutes for each hour within time range

[JackBauer]

Hello friends,

suppose you have a time range from 2020-01-01 17:05 to 2020-01-01 19:25 .

How to calculate the number of minutes for each hour.

We have:

55 min for 17th hour (from 17 to 18)
60 min for 18th hour (from 18 to 19)
25 min for 19th hour (from 19 to 20)
0 min for 20th hour (from 20 to 21)

Probably there will be 24 columns created for each hour, but I can't figure out a formula.

To make this harder, what if time range is spanning between few days..

[FDibbins]

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Mon 03 Aug 2020) is actually 44046

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

Having said that, you would be looking for times between ...

	O	P
31	17:05	0.711806
32	18:00	0.75
33	19:00	0.791667
34	19:25	0.809028

[FDibbins]

Adding days to this just means you would need to add 1 where necessary to the appropriate decimals