How to return BLANK in cell if time = 12:00 Am (0:00) in the cell

Occasional Contributor

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 sept12:00 AM012:00 AM0,000,00   
mardi, 13 sept12:00 AM012:00 AM0,000,00   
mercredi, 14 sept12:00 AM012:00 AM0,000,00   
jeudi, 15 sept12:00 AM012:00 AM0,000,00   
vendredi, 16 sept12:00 AM012:00 AM0,000,00   
samedi, 17 sept8:30 AM305:00 PM8,008,00   
dimanche, 18 sept12:00 AM012:00 AM0,000,00   
    Total Hrs:8,00   
         
2 Replies

@AnnieMaisonneuve 

You could use the custom format hh:mm AM/PM;;

(Note the two semicolons at the end)

Hi Hans,
i'ts working! Awesome