Alex_james
New member
Hi everyone,
I'm building an RPA bot in Excel to automate invoice processing. It picks up invoice creation dates from text files, but I need to calculate the actual processing time, excluding weekends.
Here's the twist: My bot works on Saturdays (unlike the standard Monday-Friday workweek). However, invoices might arrive any day, including Saturdays.
I've tried using DATEDIF to calculate the total time difference, but I'm struggling to exclude weekend hours while considering Saturdays as a working day for my specific workflow.
I've seen some solutions online that involve WEEKDAY functions and custom formulas for weekend exclusion. However, I haven't found one that caters to a non-standard workweek definition (Saturday as working day).
Does anyone have experience with crafting formulas for such scenarios? Any guidance or resources (like sample formulas) would be incredibly helpful!
(P.S. If you're looking to brush up on your Excel date and time manipulation skills, check out Date and Time Calculator
I'm building an RPA bot in Excel to automate invoice processing. It picks up invoice creation dates from text files, but I need to calculate the actual processing time, excluding weekends.
Here's the twist: My bot works on Saturdays (unlike the standard Monday-Friday workweek). However, invoices might arrive any day, including Saturdays.
I've tried using DATEDIF to calculate the total time difference, but I'm struggling to exclude weekend hours while considering Saturdays as a working day for my specific workflow.
I've seen some solutions online that involve WEEKDAY functions and custom formulas for weekend exclusion. However, I haven't found one that caters to a non-standard workweek definition (Saturday as working day).
Does anyone have experience with crafting formulas for such scenarios? Any guidance or resources (like sample formulas) would be incredibly helpful!
(P.S. If you're looking to brush up on your Excel date and time manipulation skills, check out Date and Time Calculator
Last edited by a moderator: