Splitting values of cell
Solved/Closed
Related:
- Based on the values in cells b77 b81
- Help me to add particular cells ✓ - Excel Forum
- Two values to find on the same cell ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- Pate values - Office Software Forum
- #Value - Excel Forum
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 2, 2010 at 07:52 AM
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