-
Content Count
62 -
Joined
-
Last visited
Community Reputation
10 NeutralAbout Katie Event
-
Rank
Registered User
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
Flood Alerts Sheffield Autumn 2019
Katie Event replied to Vaati's topic in Sheffield News & Discussions
Ecclesall Road now open - These roads are now open (8:25am): Ecclesall Rd Hawke St/Upwell St Handsworth Rd/White Rose Mickley Lane is passable with care Bawtry Rd @ Park House Lane - one lane re-opened Please take care whilst driving this morning #sheffieldfloods -
Flood Alerts Sheffield Autumn 2019
Katie Event replied to Vaati's topic in Sheffield News & Discussions
Streets Ahead are reporting one side of Ecclesall Road is closed: These roads remain closed this morning (8am): Bochum Parkway Brightside Lane Fife St Green Lane/Butterthwaite Ecclesall Rd (one side) Whitley Lane Hawke St/Upwell St Mickley Lane (partial) Bawtry Rd @ Park House Lane We'll keep you updated #Sheffield Does anyone know which side and which section? -
Some of the advice here is wrong. You need to get a ticket from the machine every time - however a ticket for one hour is free. It used to be two hours with no ticket. It's one of those machines where you enter your reg number. You cannot return on the same day as I have been told that they will claim that, for example, if you were there at 10am when you went to Costa, and 5pm when you picked up some milk at Tesco, that you were there for 7 hours in total.
-
Excel query - formula for setting a maximum value
Katie Event replied to Grahamfff's topic in Computer & Tech Chat
I haven't forgotten since post 7 -
Excel query - formula for setting a maximum value
Katie Event replied to Grahamfff's topic in Computer & Tech Chat
I don't use Excel as it won't run on my operating system. I stand corrected as to the way the function works in Excel though - as altus says, eveiddently MS have written Excel so it recognises "17:00" as a time, which is useful to know. I haven't used Excel since about 2007, and it certainly didn't used to do so! As for adding 12:00 to 13:00 and getting the answer 01:00 - I guess whether or not that is useful depends on whether you want the answer 25 hours or 1am! -
What does WPS office offer for the price that LibreOffice doesn't do for free?
-
Excel query - formula for setting a maximum value
Katie Event replied to Grahamfff's topic in Computer & Tech Chat
https://postimg.org/image/8r3fompfr/ I get an Error in LibreOffice, which has the same function library. The MS Excel help page says: MIN(number1, [number2], ...) The MIN function syntax has the following arguments: Number1, number2, ... Number1 is optional, subsequent numbers are optional. 1 to 255 numbers for which you want to find the minimum value. I don't see how it can compare the value of B£+C3 to 17:00 - the speech marks you've put around it mean Excel sees it as a piece of text. -
Excel query - formula for setting a maximum value
Katie Event replied to Grahamfff's topic in Computer & Tech Chat
That will attempt to display the smallest value out of the value in B3, the value in C3 or the text string 17:00 - the latter doesn't have a numerical value, so the formula won't work, surely? -
Car Wash/Valeting Thread- No Advertising
Katie Event replied to RichMason's topic in Sheffield News & Discussions
There is a hand car wash on Abbeydale Road about a mile further in to the city from Tesco. -
Excel query - formula for setting a maximum value
Katie Event replied to Grahamfff's topic in Computer & Tech Chat
How did you get on Grahamfff? -
Roads closed due to bike event 19/03/2017
Katie Event replied to Dggsheffield's topic in Sheffield News & Discussions
I've never understood why people object to threads going "off topic" It would be weird if conversations stayed on one topic all the time. Meeting up with friends would be strange ... "I'm sorry we can't talk about what happened in the football, as out topic for this coffee is 'Christine from accounts'" -
Max's suggestion is probably easiest, depending on what exactly you are trying to achieve. You could alternatively embed another sheet using Insert/Object
-
Excel query - formula for setting a maximum value
Katie Event replied to Grahamfff's topic in Computer & Tech Chat
=MIN(HOUR(a1-a2), 6) Make sure cell is formatted as numbers, not time. ---------- Post added 21-03-2017 at 21:22 ---------- I was thinking about this on the ride home. The above will only work for whole hours. When calculating in hours and minutes, Excel uses decimal fractions of the day - so 1 hour is 0.41666666. When you format that value as Time (Format/Cells) it is displayed as 1:00 - but the *value* is 0.4166666. 6 hours is a quarter of a day - or 0.25, so =MIN(B1-A1,0.25) will work for all times in the same day, but you need to make sure the answer cell is formatted as time. Because of the fact that Excel calculates time as a fraction of a day that it didn't work when you were doing it - one time minus another can only range between -1 and 1 (rounded) hence it is important to format as time, and hence why the '6' value in your formula wasn't apparently doing anything. If you are going to use it in a further calculation (for example you want to calculate wages based on the time by multiplying by an hourly rate) you will need to multiply by 24 because the value underlying the time display is a fraction of a day. It won't cope with time periods spanning midnight though - if you want to do that you will need to enter a time and a date, so Excel knows, for example, that if A1 has 23:00 in it and A2 has 02:00 in it, that the 2am time is 3 hours later than A1, not 21 hours earlier. -
There were some waxwings in Millhouses Park a fortnight since. I haven't seen any more recently.