How to return BLANK in cell if time = 12:00 Am (0:00) in the cell
Context: timesheet.
If my employee enters nothing, the cell returns12:00 AM. In this case I don't want to display anything. I want a blank cell. How to create a custom format in this case? or a formula? Thank you for your help
Same thing is employee enter no break time, because he did not work that day, the cells returns 0, I would like it to be blank.
Note I use french excel.
| lundi, 12 sept | 12:00 AM | 0 | 12:00 AM | 0,00 | 0,00 | | | |
| mardi, 13 sept | 12:00 AM | 0 | 12:00 AM | 0,00 | 0,00 | | | |
| mercredi, 14 sept | 12:00 AM | 0 | 12:00 AM | 0,00 | 0,00 | | | |
| jeudi, 15 sept | 12:00 AM | 0 | 12:00 AM | 0,00 | 0,00 | | | |
| vendredi, 16 sept | 12:00 AM | 0 | 12:00 AM | 0,00 | 0,00 | | | |
| samedi, 17 sept | 8:30 AM | 30 | 5:00 PM | 8,00 | 8,00 | | | |
| dimanche, 18 sept | 12:00 AM | 0 | 12:00 AM | 0,00 | 0,00 | | | |
| | | | | Total Hrs: | 8,00 | | | |
| | | | | | | | | |
