Have I entered this incorrectly?
=IF(L9<=L10,IF(L10>L11,TEXT(K10,"DDDD"&" Total Hours"),""),"")
<colgroup><col width="56" style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048;">
<col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;" span="2">
<col width="64" style="width: 48pt;" span="6">
<col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;">
<col width="64" style="width: 48pt;">
<col width="155" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5668;">
<tbody>
</tbody>The returned value is correct, except that it replaces the H & s in "Hours" with zeros.
Help
=IF(L9<=L10,IF(L10>L11,TEXT(K10,"DDDD"&" Total Hours"),""),"")
9124889 | 1/10/2019 8:45 | 1/10/2019 9:30 | REG | 71745570 | 8:45 | 9:30 | 0:45 | 0.75 | 1/10/2019 | 0.75 | |
9125743 | 1/10/2019 8:45 | 1/10/2019 9:30 | REG | 71745570 | 8:45 | 9:30 | 0:45 | 0.75 | 1/10/2019 | 1.50 | |
9114501 | 1/10/2019 8:45 | 1/10/2019 9:30 | REG | 71745570 | 8:45 | 9:30 | 0:45 | 0.75 | 1/10/2019 | 2.25 | |
4012636 | 1/10/2019 8:45 | 1/10/2019 9:30 | REG | 71745570 | 8:45 | 9:30 | 0:45 | 0.75 | 1/10/2019 | 3.00 | |
9125743 | 1/10/2019 9:30 | 1/10/2019 14:39 | REG | 71745570 | 9:30 | 14:39 | 5:09 | 5.15 | 1/10/2019 | 8.15 | |
4012636 | 1/10/2019 9:30 | 1/10/2019 14:39 | REG | 71745570 | 9:30 | 14:39 | 5:09 | 5.15 | 1/10/2019 | 13.30 | |
9114501 | 1/10/2019 9:30 | 1/10/2019 14:39 | REG | 71745570 | 9:30 | 14:39 | 5:09 | 5.15 | 1/10/2019 | 18.45 | |
9124889 | 1/10/2019 9:30 | 1/10/2019 14:39 | REG | 71745570 | 9:30 | 14:39 | 5:09 | 5.15 | 1/10/2019 | 23.60 | Thursday Total 0our0 |
4012636 | 1/11/2019 8:03 | 1/11/2019 8:42 | REG | 71745570 | 8:03 | 8:42 | 0:39 | 0.65 | 1/11/2019 | 0.65 |
Help