"As long as you continue to exist, I cannot awake from my nightmare. You are my darkness." —Cloud Strife
Happy birthday, @A Zebra, you loser!
IDEK?
Maybe you lied. Ever think of that?
Stop being lazy and hop to it! ;)
Feel awesome for what?
Update Notes for February 11: Updated Current Projects section Updated Upcoming Projects section Updated Completed Projects section Updated 2017 YouTube timeline
@cstar.
:) View attachment 46357
One final thing, @Mixt: Today while working on an assignment in IT 111, which focuses specifically on spreadsheets, I discovered you can combine formulas, such as averaging and rounding in one cell without having to do it in two separate cells, typically making it neater. Like, in my activity log, I have two columns basically giving the same information, just that one is rounding. Anyway, so for example: View attachment 46353 View attachment 46354 View attachment 46355 How do I do this with times? When I try, it won't work the same way it does with regular numbers: View attachment 46356
Here are the details on what was fixed in the YouTube timeline: A missing entry was added to the 2010 timeline: January 10, which had one upload Fixed total number of updates and uploads for January 2010 from 7 to 8 Fixed total number of updates for 2010 from 57 to 58 Fixed total number of uploads for 2010 from 149 to 150 Fixed total number of updates for August 2015 from 17 to 15 Fixed total number of updates for 2015 from 184 to 182 Fixed total number of uploads for 2015 from 806 to 809 Fixed total number of uploads for May 2016 from 70 to 62 A missing entry was added to the 2016 timeline: June 29, which had four uploads Fixed total number of updates for June 2016 from 9 to 10 Fixed total number of uploads for June 2016 from 132 to 134 Fixed total number of uploads for October 2016 from 18 to 24 Fixed total number of updates for 2016 from 85 to 86 Total number of uploads for 2016 coincidentally stayed the same (630) due to both the up and down adjustments Fixed total number of uploads for January 21, 2017, from 5 to 4 Fixed total number of uploads for January 2017 Fixed overall total updates and uploads In most of these cases, the issue was mathematical errors on my part or seeing one number in my automatic spreadsheet calculations and then accidentally writing a different number. Everything is now being automatically calculated with spreadsheets, however.
Impressions?
@Mish, @Novalentine, get your lazy asses up because it's birthday party time!
Update Notes for February 5: Updated Current Projects section Updated Completed Projects section Updated 2017 YouTube timeline I've also fixed a number of errors with the YouTube timeline, which is why I am a day late on this. I will post details tomorrow.
One thing I like about Excel is that even with the large workbook I have for the activity log, it opens instantly, whereas in OpenOffice Calc, it...
@Mixt, I've fully converted my log over to Excel now. I just ended up going with the original solution you gave me of changing =IF(HOUR(C2)>12,C2-1,C2) to =IF(HOUR(C2)<12,C2+1,C2), so instead of subtracting one hour when the time is any time that is 11:59 PM or below—specifically, between 12:00 PM and 11:59 PM—we add one hour when the the time is any time that is 12:00 AM or above—specifically, between 12:00 AM and 11:59 AM. (Do I have that down right?) It works exactly the same way, there's just no indication now of what's what as mentioned. So can I use conditional formatting to highlight cells that are having one hour added to them (AM) or, vice-versa, highlight cells that are having nothing being done to them (PM)?
Only if you absolutely cannot think of the game title.
Update! Doesn't seem like that solution works that well: View attachment 46347 Future dates which can be easily fixed, but too time consuming as you can't get specific enough with the find and replace feature there; negative average, causing an error with the rounding formula. Edit: I wonder if it's possible to use conditional formatting with the formula to highlight the numbers where we add one or vice-versa where we don't add one. That would care care of there being an indication.
@Mixt, I'm still using OpenOffice Calc for only this document because I haven't really gotten around to it and it's much larger than my other spreadsheets. Anyway, you provided me an excellent workaround to move the AM times forward instead; however, in your opinion, what do you think is better? Moving the AM times forward or keeping it with the PM times moved backward and using the following solution to deal with the issue of negative time values? https://support.microsoft.com/en-us...e-value-are-displayed-as-pound-signs-in-excel What does changing the date system do, exactly, and does it potentially cause any other issues or do you see it as a good solution? (The solution was provided by Microsoft themselves.) The reason I ask which is better, in your opinion, is because when we move the AM times forward, there's really no indication under the AM/PM column as seen in the third post's screenshot. However, when we move the PM times backward, there is an indication: the negative sign as well as how many minutes behind 12:00 AM the time is. Even though the calculations are the same regardless—for example, the average will be 10:53 PM either way—I guess it's just good to know exactly what you're finding the average of when it's between two different days as when it's all either AM or PM on the same day or you do want to find the averages between AM and PM on the same day, you can just use the plain ol' average formula, but since we're finding the averages between the PM times of the previous day and the AM times of the current day, we need an IF conditional. The latest—or earliest, if you'd rather—time I currently have logged for going to bed around is 5:22 AM, and I can't ever, for example, foresee myself going to bed for Saturday at 12:30 PM on Sunday, which would make finding the average even more complicated. I don't think anything will ever go past 5:30 AM, to be honest, as even that 5:22 AM was the only time logged for the 5:00 AM - 5:59 AM range so far since I've started this project. The more common times are between the 11:00 PM and 1:59 AM range. Ultimately, the decision is up to me, but it never hurts to solicit others' opinions, right? :)
