Forum Discussion
Solved
Calculate hours between two date/time columns and exclude weekends
Hi all, first post here so be nice since im a beginner. 🙏 Im trying to caculate the hours between two columns including start date/time and end date/time and I want to exlude the weekends. I have...
you can identify the number of weekends between the 2 dates via the below thread :
And via datediff get the hours count between the 2 dates and substract the hours based on number of weekends * 24
NandanHegde
Super User
Super UserYou can identify whether a date is weekday or weekend bbbby below aspect :
if(WEEKDAY([Date],2)>=6,"Weekend","Weekday")
And you can use DATEDIFF to identify the diff in hours between 2 dates:
Can you also plz state what you mean by exclude weekends