Subtract 1hr in excel and adjust the result if it falls outside office hours

hello experts

need your help please on how i can subtract 1 hour from a date and time, and if the result falls outside working hours, it would be adjusted to the last working hour. All results should only fall between Mon - Fri, 9:00 - 17:00

example:

column A result should be
lu 01/03 15:00 - lu 01/03 14:00
vi 05/03 13:00 - vi 05/03 12:00
vi 26/02 08:00 - ju 25/02 17:00
sá 27/02 18:00 - vi 26/02 17:00
lu 01/03 06:00 - vi 26/02 17:00

i can only subtract the 1 hour.. but not sure how to proceed how to formulate the working hours.

Thanks in advance for the help!!

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

sorry about that... attaching the sample file here

hello rick..

thank you for looking into the file. input and output should be in date and time. i am attaching a new excel file with the correct format.

any help from anybody?

Try this in cell B2:

=IF(OR(WEEKDAY(A2,2)>5,MOD(A2,1)<10/24),WORKDAY(A2,-1)+17/24,A2-1/24)