↓ Advertise on Defender2 ↓

Home > Off Topic > MSO - excel spreadsheet experts
Post Reply  Down to end
Page 2 of 2 <12
Print this entire topic · 
Caterham



Member Since: 06 Nov 2008
Location: Birmingham
Posts: 6260

England 2011 Defender 110 Puma 2.4 XS CSW Stornoway Grey
Eduardo,

I'm almost there with it now so I'll stick with what I've got but will have a look at the option you have given (thank you very much) for future use.

I do have a problem tho....the values against 00:00 hrs aren't being calculated Sad I can see why but not sure how to resolve.

I've broken down what I need into 4 values;
all Saturday and Sunday
Mon to Fri (7am - 7pm)
Mon to Fri 00hrs to 7hrs
Mon to Fri 19hrs to 23hrs

=IF(AND(OR(D4="MON",D4="TUE",D4="WED",D4="THU",D4="FRI"),AND(E4>F40/24),AND(E4<7>0/24),AND(E4<7>18/24),AND(E4<24/24)),B4,0)

once again thanks very much for your suggestion. in the short term I'd like to understand how to include values against 00:00 hrs and ideally pull the last 2 formula above into 1 formula.


thank you very much in advance.

Thumbs Up
Post #431920 18th Jun 2015 2:59pm
View user's profile Send private message View poster's gallery Reply with quote
Eduardo



Member Since: 28 Aug 2008
Location: RegiĆ³n Metropolitana
Posts: 2108

Chile 2007 Defender 110 Puma 2.4 SW Stornoway Grey
Easy one Mr. Green

Here it is complete

Gives 0 for Sat-Sun
1 for 7 to 19 Mon-Fri
2 for 0 to 7 Mon-Fri
3 for 19 to 24 Mon-Fri


Click image to enlarge


Same principle of the other one

First IF check the day 0 for Sat-Sun and 1 for the rest
The second is an annidated IF
first IF ask if the hour is between 7 and 19 if so is 1, if not
second if check if the hour between 0 and 7 if so, 2 if not is 3

When you multiply both IF the formula gives you 0,1,2 or 3

Cheers again



Cheers! Eduardo

MY 2007 110 SW PUMA 2.4: Big Fog of 64'
MY 1994 Jayco 1207 Folding camper: "El Tremendo"

Click image to enlarge
Post #431928 18th Jun 2015 3:44pm
View user's profile Send private message View poster's gallery Reply with quote
blackwolf



Member Since: 03 Nov 2009
Location: South West England
Posts: 16808

United Kingdom 2007 Defender 110 Puma 2.4 DCPU Stornoway Grey
Eduardo wrote:
....
Sorry but PhP make strange things when I put the formula in the post
....


It may well be mistaking your text strings as an SQL injection attack on the forum. This tends to happen with anything that vaguely resembles SQL.
Post #431945 18th Jun 2015 4:32pm
View user's profile Send private message View poster's gallery Reply with quote
Caterham



Member Since: 06 Nov 2008
Location: Birmingham
Posts: 6260

England 2011 Defender 110 Puma 2.4 XS CSW Stornoway Grey
Thud

.....I think I should have stuck to delivering newspapers !




right I'm gonna give it another go Thumbs Up

thank you - will see how I get on.
Post #431955 18th Jun 2015 5:18pm
View user's profile Send private message View poster's gallery Reply with quote
Caterham



Member Since: 06 Nov 2008
Location: Birmingham
Posts: 6260

England 2011 Defender 110 Puma 2.4 XS CSW Stornoway Grey
here's goes - another one for the experts......


I've got quite a large excel document with approx. 30 tabs each with a photograph. I'm trying to print the excel to pdf and unfortunately although I'm asking it to print the 'entire worksheet' it's simply pdf'ing one page at a time and it's asking for a file name for each tab !!! ?

I want it to simply produce one pdf file with all of the tabs/pages.

any help much appreciated.
Post #680520 21st Jan 2018 7:31pm
View user's profile Send private message View poster's gallery Post Reply
Post Reply  Back to top
Page 2 of 2 <12
All times are GMT

Jump to  
Previous Topic | Next Topic >
Posting Rules
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Site Copyright © 2006-2024 Futuranet Ltd & Martin Lewis
DEFENDER2.NET RSS Feed - All Forums