Hello,
I’m trying to calculate number of quarter hours in data that looks like this [brackets indicate separate cells].
Days Start time End time
[MTuWThF] [10:00PM] [2:00AM]

So, in the example, the number of quarter hours is 5 days X 4 hours X 4 quarters = 80

I have a wide variety of day combos – MTuW, MW, ThF, SaSu, MTWTh etc. It’s also important that I’m able to calculate # of hours for times that span from am to pm and pm to am.
I think I can figure out counting the days to get that multiplier, but what about an easy way to count number of hours?

And bonus would be handling ½ and ¼ hour times – 2:45, 3:15 etc.

It’s a process I’ll have to apply to a couple thousand lines of data several times a year, so the more turnkey, the better. Any help is most appreciated, thanks!
Tom