Hello,
I have been trying to combine 2 IF statements for 2 hours and have tried multiple variations and researched the board for answers but still can't get it to work.
Nested IF statement in cell F6. Times are in range D3:D6. If the times are not filled in then leave blank.
Scenario: Employees Time in and Timeout multiple times as the example below:
<colgroup><col><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
2nd Example: Employees Time in and Timeout once as the example below:
<colgroup><col><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Start Time – End Time – Start Time – End Time
=IF(AND(COUNT(D3:D6)=4),MROUND((D4-D3+(D4<=D3))*24,0.25)+MROUND((D6-D5+(D6<=D5))*24,0.25),"")
Start Time – End Time
=IF(MROUND((D6-D3+(D6<=D3))*24,0.25),MROUND((D6-D3+(D6<=D3))*24,0.25),"")
Thank you so much for your support.
Elaine
I have been trying to combine 2 IF statements for 2 hours and have tried multiple variations and researched the board for answers but still can't get it to work.
Nested IF statement in cell F6. Times are in range D3:D6. If the times are not filled in then leave blank.
Scenario: Employees Time in and Timeout multiple times as the example below:
1st Example: Clocking Record | |
Time In | 8:00 AM |
Time Out | 10:00 AM |
Time In | 2:00 PM |
Time Out | 6:00 PM |
<colgroup><col><col></colgroup><tbody>
</tbody>
Total Hrs Worked | 6 |
<tbody>
</tbody>
2nd Example: Employees Time in and Timeout once as the example below:
Clocking Record | |
Time In | 8:00 AM |
Time Out | |
Time In | |
Time Out | 6:00 PM |
<colgroup><col><col></colgroup><tbody>
</tbody>
Total Hrs Worked | 10 |
<tbody>
</tbody>
Start Time – End Time – Start Time – End Time
=IF(AND(COUNT(D3:D6)=4),MROUND((D4-D3+(D4<=D3))*24,0.25)+MROUND((D6-D5+(D6<=D5))*24,0.25),"")
Start Time – End Time
=IF(MROUND((D6-D3+(D6<=D3))*24,0.25),MROUND((D6-D3+(D6<=D3))*24,0.25),"")
Thank you so much for your support.
Elaine