Splitting values of cell
Solved/Closed
Related:
- Splitting values of cell
- Based on the values in cells b77 b81 ✓ - Forum - Excel
- Based on the values in cells b77 b81 which function can automatically return the value in cell 77 ✓ - Forum - Excel
- Conversion of values already present in cells ✓ - Forum - Excel
- Fixing populating values into textboxes based on showing data in listbox ✓ - Forum - Excel
- Find values based on colum and sum in a table - Forum - Office Software
2 replies
rizvisa1
Feb 2, 2010 at 07:52 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 2, 2010 at 07:52 AM
Lets say your total is in cell A1 and you want regular 40 hours to show up in B1 and OT in C1
then in B1, you need to type =IF(a1 <=40, a1, 40)
and in C1, you need to type =IF(A1<40, 0, A1- 40)
B1 formula is saying that if hours are more than 40, then 40 is the regular worked our and rest would be OT
C1 formula is saying that if hours are less than 40, then there is no OT else any thing over 40 is OT
then in B1, you need to type =IF(a1 <=40, a1, 40)
and in C1, you need to type =IF(A1<40, 0, A1- 40)
B1 formula is saying that if hours are more than 40, then 40 is the regular worked our and rest would be OT
C1 formula is saying that if hours are less than 40, then there is no OT else any thing over 40 is OT