•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Network Days w/ timestamps
Our take
To measure the duration in business days between two dates that include timestamps, you’ll need to create a formula that considers both the time of day and the specific business hours. For example, if your start date is "1/5/2026 11:31 AM" and your end date is "1/7/2026 6:30 AM," the duration is two business days. However, if the start time is after 3 PM, like "1/5/2026 3:31 PM," it should count as starting on the next business day, resulting in
So I'm trying to measure duration (business days) between dates but have to factor in the timestamps as well.
Date and timestamps are in the same cell in these reports.
Reference of what I'm looking at/for:
1/5/2026 11:31AM - start date
1/7/2026 6:30AM - end date
This would be 2 business days
Now if an occurrence for the first date happens after 3pm on any given date, that should count towards the next business day. So start date for 1/5 at 3pm would count towards 1/6 as a start date.
1/5/2026 3:31PM - start date
1/7/2026 6:30AM - end date
This would be 1 business day
How do I write this formula out?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#business intelligence tools#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#AI formula generation techniques#Excel compatibility#formula generator#Excel alternatives#Network Days#timestamps#business days#start date#end date#duration#Next business day#1 business day#date#3pm#formula