Calculating working hours

[snash]

Hi there,

I'm trying to calculate the following scenarios into formulas:
I will have 3 columns: basic time, 1.5 and double time.

Can anyone help?

Monday - Thursday 08.00 – 16.30 is standard working day 8Hrs less .5 for lunch 06.00-08.00 am = T1/2 16.30 – 00.00 midnight = T1/.2 00.00 – 06.00 = T2 Friday 08.00 -15.30 is standard working day 7hrs less .5 for lunch 06.00-08.00 am = T1/2 15.30 – 00.00 midnight = T1/.2 00.00 – 06.00 = T2 Saturday 08.00-12.00 = T1/2 - 4 hrs 12.00-08.00 = T2 Sunday T2 all day

 

[snash]

I know this is a big ask but any help would be greatly appreciated.

 

[Cubist]

Your post lacks details thus indecipherable. It's unclear what you're showing and wanting to accomplish.
Try adding more details and the expected output for a small sample set of data.
Update your profile to your current XL version.