Revisions to SharePoint list Formula to calculate hours

deleted 26 characters in body; edited tags

Source Link

edited Mar 26, 2023 at 16:36

46.4k
22
31
63

Dears all Greetings,

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

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

best regards

edited tags

Link

edited Mar 26, 2023 at 13:28

user19328544

37
6

sharepoint-online sharepoint-designer list sharepoint-foundation

added 17 characters in body

Source Link

edited Mar 26, 2023 at 13:26

user19328544

37
6

Dears all Greetings,

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.

best regards

Source Link

asked Mar 26, 2023 at 13:09

user19328544

37
6

Loading

Stack Exchange Network

Return to Question