1

I have a SharePoint list with two columns Start Time and end time. I want the Formula to calculate the time between the start time and end time in hours only.

If the end time is still pending (empty) value should be 0. The formula should calculate only working days and exclude weekends.

1 Answer 1

0

Try using formula like:

=IF(ISBLANK([Column2]),"0",TEXT([Column2]-[Column1],"h"))

OR:

=IF(ISBLANK([Column2]),0,TEXT([Column2]-[Column1],"h"))

To exclude weekends, follow below posts:

  1. Exclude weekends
  2. Calculating Dates Excluding Weekends
  3. Microsoft Lists - Date formula to exclude weekends
  4. Calculate days excluding weekends in SharePoint
1
  • Or try using hh like: =IF(ISBLANK([Column2]),0,TEXT([Column2]-[Column1],"hh")) Apr 5, 2023 at 10:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.