Formula required

[Ian66]

In the screen shot below, it relates to flexi time showing a decimal flexi (either a plus or minus for the day. Merged cell G/H6 is a day of the week and updates automatically depending on the date in merged cell G/H5.

Rotated hours of work as follows: Monday work 8 hours - Tuesday work 6 hours - Wednesday 5 hours - Thursday 6 hours - Friday 5 hours. Currently I’m currently typing in the rotated hours in merged cell I2. Is it possible for cell I2 to update automatically with the relevant hour depending on the day in merged cell G/H6.

In example below, a person is rotated to work 5 hours, but has worked 50 minutes longer returning a decimal flexi amount of 0.83.

 

[Alex Blakenburg]

I suspect there is a lot more to this but lets start with this.
In I2 try this:

=TIME(CHOOSE(WEEKDAY(G5,2),8,6,5,6,5),0,0)

It doesn't seem to make sense to hard code those hours though. I would think you would want to have a lookup table but I suspect it would need more criteria than just the day of the week.

 

[Ian66]

I suspect there is a lot more to this but lets start with this.
In I2 try this:

=TIME(CHOOSE(WEEKDAY(G5,2),8,6,5,6,5),0,0)

It doesn't seem to make sense to hard code those hours though. I would think you would want to have a lookup table but I suspect it would need more criteria than just the day of the week.

Sorry if my query didn’t make much sense, but the formula you provided appears to work and what I wanted. Much appreciated – thanks Ian

 

[Alex Blakenburg]

You're welcome. Glad we could help.