While calculating the number of days between two given dates, it automatically excludes the weekends (Saturday, Sunday). It optionally excludes any other holidays provided as dates (state, federal ...

Read latest news today, breaking news headlines, Top news. Discover national and international news on economy, politics, ...

Click the drop-down arrow in this area and choose either of the two "Date" options. The long number in the cell with transform a date, which will be the midpoint between your two given dates.

This simple Google Sheets formula will show you the number of days between two dates.

Click "OK" and the total number of hours, except for weekends, that exist between your two sets of dates and times will appear.