Forum Discussion
AnnieMaisonneuve
Oct 19, 2022Copper Contributor
How to return BLANK in cell if time = 12:00 Am (0:00) in the cell
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 | |||||||
- AnnieMaisonneuveCopper ContributorHi Hans,
i'ts working! Awesome