ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Making weekend days working days - the system cuts the working tim (https://www.excelbanter.com/excel-discussion-misc-queries/189461-making-weekend-days-working-days-system-cuts-working-tim.html)

fluffy

Making weekend days working days - the system cuts the working tim
 

When I make weekend days working days, I can not make the working times
mimic the week day times of 8 to 12 and 1 to 5.

For Saturday and Sunday, the system will only take 8:00 am to 12:00 pm and
1:00 pm to 2:00 pm.

What up! Is there something I have to turn off?

Thanks
--
Fluffy

Mike H

Making weekend days working days - the system cuts the working tim
 
How are you turning weekends in working days in Excel because with the
exception of a few functions Excel doesn't distinguish. can we see you
formula?

Mike

"Fluffy" wrote:


When I make weekend days working days, I can not make the working times
mimic the week day times of 8 to 12 and 1 to 5.

For Saturday and Sunday, the system will only take 8:00 am to 12:00 pm and
1:00 pm to 2:00 pm.

What up! Is there something I have to turn off?

Thanks
--
Fluffy



All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com