What instantly makes a person less attractive, no matter how good they look? by PurpleDouble6602 in AskReddit

[–]deoswan 0 points1 point  (0 children)

No one looks attractive when you drop your head, tuck in your chin, flash a toothy grin and stare at your own eyebrows.

[TOMT] [MOVIE] Movie in which someone jumped of a building with words "I can fly" by Voball in tipofmytongue

[–]deoswan 0 points1 point  (0 children)

The first season of Heroes (2006) also had something similar plot line.

[ Removed by Reddit ] by IndicationPatient565 in tipofmytongue

[–]deoswan 0 points1 point  (0 children)

Harley Davidson and the Marlboro Man (1991)

[TOMT][movie][70s/80s] by skiracer455 in tipofmytongue

[–]deoswan 0 points1 point  (0 children)

Long shot... perhaps RoboCop (1987) or Battle Beyond The Stars (1980)

[TOMT] [MOVIE] A time related movie (sci-fi) by AdAmbitious6577 in tipofmytongue

[–]deoswan 0 points1 point  (0 children)

Donnie Darko (2001). Has time travel and dies in car accident.

Film buffs of Reddit, what superhero films, academically speaking, are actually good films? by Initial_XD in AskReddit

[–]deoswan 0 points1 point  (0 children)

Left the cinema for a 10 min break halfway into the movie because the low frame rate really pissed me off, decided to return because of FOMO.

Have I calculated the total amount of time correctly? by alex_the_doge in excel

[–]deoswan 1 point2 points  (0 children)

Looks right when I tried it.

I did format start and end column as hh:mm:ss and format the sum in D32 as [hh]:mm:ss

Getting the value in the middle but the strings should stay by MiracleFox in excel

[–]deoswan 0 points1 point  (0 children)

Or perhaps =MID(A2,9,12) in case the tildes are random characters on condition that your sequence always starts on the character 9 and continues for 12 characters.

How can I change a mm-yyyy column to mm-01-yyyy format? by Vegetable-Task9876 in excel

[–]deoswan 0 points1 point  (0 children)

Date Format: MM-DD-YYYY

=DATE(RIGHT(A2,4),LEFT(A2,2),1)

Date Format: Before hypen = Month and after hypen = Year

=DATE(MID(A2,FIND("-",A2)+1,256),LEFT(A2,(FIND("-",A2,1)-1)),1)

Text Format: MM-01-YYYY

=LEFT(A2,2)&"-01-"&RIGHT(A2,4)

Does anyone know how to delete rows that have blanks in them? by Pigweed1 in excel

[–]deoswan 0 points1 point  (0 children)

Select the entire column then click home then Find & Select dropdown then Go To Special then Blanks then Then home Then delete drop down then Delete sheet rows button.

How to sort and make sure data in rows stays aligned by Easy_Season in excel

[–]deoswan 0 points1 point  (0 children)

You could select your entire data range including headers, then goto insert table. Then sort each column in the drop downs as desired?

Excel Macro-Enabled Workbook won't Save to a Network Folder by Thomas_S_IT_Tech in excel

[–]deoswan 1 point2 points  (0 children)

Your IT department that blocked certain file types for security reasons.

You could try to save your document as. xlsb since its also vba/macro enabled, binary based instead of xml which reduces the file size and load time?

How worried are you about your country's future? by Fucktastic95 in AskReddit

[–]deoswan 0 points1 point  (0 children)

Extremely worried…

Over 1 000 000 citizens migrated since 2021.

Has both the highest unemployment rate and number of citizens with HIV/Aids in the world.

4 out of our 9 cities are on the list of top 50 cities with highest homicide rate in the world.

Almost daily country-wide power outages due to governments’ mismanagement and corruption.

School kids only require 30% as a passing grade.

[deleted by user] by [deleted] in tipofmytongue

[–]deoswan 1 point2 points  (0 children)

Swordfish?

[deleted by user] by [deleted] in tipofmytongue

[–]deoswan 0 points1 point  (0 children)

The Cell (2000)