Display 0 if one value is empty

[TheSlawekG]

Hi,

I have an SP list as below:

My current formula for the column "Hours per Shift" is =TEXT([Time Out]-[Time In],"h"); it is being calculated fine when I have two dates. How I could display 0 if the "Time Out" column is empty so the calculation would be done only if two columns have a date in them?

Thank you.

[rebeccas]

Just use an if statement looking to see if whichever column you choose is blank '0' otherwise put your calculation.

[v-bacao-msft · Accepted solution]

Hi @TheSlawekG ,

Please try this formula:

=IF([Time Out]="","0",TEXT([Time Out]-[Time In],"h"))

For more details on Calculated Field Formulas, please check this online doc:

https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=offic...

Best Regards,

[TheSlawekG]

Thank you!