Calculate regular and over time hours

[ExcelSur]

Hello Gurus,
I have over 9000 rows in my excel spreadsheet and I am trying get the regular hours and overtime hours. I have 1 column with total hours and I want to separate regular hours and overtime hours. I tried both IF AND and IF OR to get Reg Hours and Overtimes but didnt get the right result. I have attached a sample spreadsheet.

Really appreciate your help.

 

[AlanSidman]

Data Range

	A​	B​	C​	D​	E​
2​	Date​	Employee​	Total Hours​	Reg Hours​	Overtime Hours​
3​	43832​	John Smith​	4​	=IF(C3<=8,C3,8)​	=C3-D3​
4​	43833​	Jane Doe​	2​	=IF(C4<=8,C4,8)​	=C4-D4​
5​	43834​	Paul Sanders​	8​	=IF(C5<=8,C5,8)​	=C5-D5​
6​	43835​	Patricia Snodgrass​	12​	=IF(C6<=8,C6,8)​	=C6-D6​
7​	43836​	Superman​	15​	=IF(C7<=8,C7,8)​	=C7-D7​
8​	43837​	Spiderman​	6​	=IF(C8<=8,C8,8)​	=C8-D8​
9​	43838​	Thor​	5​	=IF(C9<=8,C9,8)​	=C9-D9​
10​	43839​	Ironman​	2​	=IF(C10<=8,C10,8)​	=C10-D10​
11​	43840​	Hulk​	16​	=IF(C11<=8,C11,8)​	=C11-D11​
12​	43841​	Ant Man​	1​	=IF(C12<=8,C12,8)​	=C12-D12​
13​	43842​	Batman​	8​	=IF(C13<=8,C13,8)​	=C13-D13​

 

[pecoflyer]

In Alan's solution instead of an expression like =IF(C3<=8,C3,8) you can also use =MIN(C3,8)

 

[ExcelSur]

Data Range

	A​	B​	C​	D​	E​
2​	Date​	Employee​	Total Hours​	Reg Hours​	Overtime Hours​
3​	43832​	John Smith​	4​	=IF(C3<=8,C3,8)​	=C3-D3​
4​	43833​	Jane Doe​	2​	=IF(C4<=8,C4,8)​	=C4-D4​
5​	43834​	Paul Sanders​	8​	=IF(C5<=8,C5,8)​	=C5-D5​
6​	43835​	Patricia Snodgrass​	12​	=IF(C6<=8,C6,8)​	=C6-D6​
7​	43836​	Superman​	15​	=IF(C7<=8,C7,8)​	=C7-D7​
8​	43837​	Spiderman​	6​	=IF(C8<=8,C8,8)​	=C8-D8​
9​	43838​	Thor​	5​	=IF(C9<=8,C9,8)​	=C9-D9​
10​	43839​	Ironman​	2​	=IF(C10<=8,C10,8)​	=C10-D10​
11​	43840​	Hulk​	16​	=IF(C11<=8,C11,8)​	=C11-D11​
12​	43841​	Ant Man​	1​	=IF(C12<=8,C12,8)​	=C12-D12​
13​	43842​	Batman​	8​	=IF(C13<=8,C13,8)​	=C13-D13​

Hello Alan,
Really appreciate your help. Thanks for taking your time to solve my issue

 

[ExcelSur]

In Alan's solution instead of an expression like =IF(C3<=8,C3,8) you can also use =MIN(C3,8)

Hi Pecoflyer,
Really appreciate your help and input. You formula also worked. Thanks again