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.
Solved! Go to 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:
Best Regards,
Just use an if statement looking to see if whichever column you choose is blank '0' otherwise put your calculation.
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:
Best Regards,
Thank you!
User | Count |
---|---|
93 | |
45 | |
19 | |
19 | |
15 |
User | Count |
---|---|
137 | |
54 | |
42 | |
42 | |
30 |