Splitting values of cell
Solved/Closed
Related:
- Based on the values in cells b77 b81
- Instagram account based in wrong country - Instagram Forum
- Excel macro to create new sheet based on value in cells - Guide
- Insert picture in Excel macro which takes the file name refrence - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77 ✓ - Excel Forum
- Based on the values in cells b77 b81 c77 ✓ - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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