354 reputation
1622
bio website
location
age 27
visits member for 4 years, 8 months
seen Jul 29 at 18:06

Mar
20
revised How can I troubleshoot a powerline (homeplug) and switch connection?
Change of solution
Mar
20
revised How can I troubleshoot a powerline (homeplug) and switch connection?
Wording
Mar
20
answered How can I troubleshoot a powerline (homeplug) and switch connection?
Mar
19
comment How can I troubleshoot a powerline (homeplug) and switch connection?
I have the details (access data) for the router that accesses the internet for us lying next to me, but can you refer me to a tutorial of how to "ping"? (Is that one sufficient: youtube.com/watch?v=6VRvs-TQSWM)
Mar
19
comment How can I troubleshoot a powerline (homeplug) and switch connection?
That's a good idea. In fact I have at least two other routers lying around. I just thought that if I plug in a router it will further complicate the setting? Right now I tried to connect the router directly to my laptop (to deactivate DHCP and update the firmware?) via one random LAN-port, but I can't access it, whatever (given) IP address from the manual I use. How do I connect it in a way that my laptop can access it locally? Because as said, I don't have two LAN ports on my laptop. :/
Mar
19
comment How can I troubleshoot a powerline (homeplug) and switch connection?
The only potential cause for this issue I can guess is: 1. Some "network cache" on my laptop that needs to be emptied?? (i.e. my laptop is highly likely the one not accepting the connection) or 2. the problem is with the fact that the switch is NOT directly behind the router (i.e. not positioned before the first PLA), but behind two PLA's (which are - naturally both "behind" the router)?
Mar
19
comment How can I troubleshoot a powerline (homeplug) and switch connection?
Thanks for asking, that is exactly the configuration which I tried and aim to get working, but that doesn't work. Which (3rd) alternative to the two scenarios you described do you see?
Mar
18
comment How can I troubleshoot a powerline (homeplug) and switch connection?
Unfortunately I only have one switch. The devolo technology supposedly supports up to 64 devices at once according to FAQ. I added a visual clarification of my network to the question.
Mar
18
revised How can I troubleshoot a powerline (homeplug) and switch connection?
added visual clarification + description
Mar
18
comment How can I troubleshoot a powerline (homeplug) and switch connection?
Your answer shows me that I may not have been clear: My www connection works just fine when I don't involve the switch. Only if I want to involve the switch to further extend the amount of hardware connected to my laptop / the network itself, then it doesn't work anymore, as the internet somehow doesn't get passed over from the powerline device to my laptop by the switch.
Mar
18
asked How can I troubleshoot a powerline (homeplug) and switch connection?
Mar
11
comment How to change the hh:mm:ss format in spreadsheets
Ok, sorry, @barryhoudini it seems to indeed work to also take a sum of those. But I have frankly problems to understand how these random numbers relate to my data? i.e. how do I manipulate my "A" column data row to work equivalent to the file you attached? Again, my times aren't initially in the [h]:mm format, but in the default custom excel format, in my case that was hh:mm, no idea why. My target format is: mm:ss or [h]:mm:ss
Mar
11
comment How to change the hh:mm:ss format in spreadsheets
I want to add that I googled around quite a lot, but all solutions that I found were related to simply summing up hh:mm data, which is much easier, if the data base is already (in) hours - inlike mine.
Mar
11
comment How to change the hh:mm:ss format in spreadsheets
Thanks Amer, I'll try this out ASAP! Sadly I have already irreversibly converted my data from OneNote to Excel at the moment. But I'll it out with a new dataset.
Mar
11
comment How to change the hh:mm:ss format in spreadsheets
Again, sadly I have little influence on the mess MS OneNote and Excel produce together, I can only try to wrap my head around of how to manipulate the existing data such as 12:20:00 (hh:mm) towards what I need. Alternatively, I have the "pure" data in OneNote, but the problem is, any spreadsheet software I tried converts my data to hh:mm(:ss) without me having a say concerning this upon import. Am I missing an import option somewhere?
Mar
11
comment How to change the hh:mm:ss format in spreadsheets
The problem why your solution doesn't work, that in my case I don't enter the data, MS OneNote does !! So it is automatic, it is already there, i.e. I cannot "prep" the Custom format! -.- And again, I don't want to have to retype all my data, then why do I need excel? Then I'm faster with pen & paper or my manual calculator!!
Mar
11
comment How to change the hh:mm:ss format in spreadsheets
Well, I actually just noticed IT WORKS correctly after I put the measures in place I described above. But not entirely, because the break-off point seems to be "100" not 60, to when a value is moved to the left. i.e. with a short array of numbers it somehow works, but if they get more, the calculation is off, because both minutes and seconds get /100 not /60 by the SUM function.
Mar
11
comment How to change the hh:mm:ss format in spreadsheets
Nope, Excel doesn't convert 90:15 to 1:30:15, so how is dividing by 60 gonna help? I tried to describe several times that dividing doesn't help. If I e.g. have the value 30:30(:00) (minutes:ss) and divide it by 60, then the new value is - yes - in minutes 00:50:50, which is more than the original value, i.e. totally wrong.
Mar
10
comment How to change the hh:mm:ss format in spreadsheets
And I used [h]:mm, but the problem is it won't work properly, because the data base is false! If excel calculates hh:mm, while the actual numbers represent mm:ss, I will get a wrong solution.
Mar
10
comment How to change the hh:mm:ss format in spreadsheets
hh:ss isn't possible as far as I know. Only hh:mm or mm:ss. What do you mean thus?