5,512 reputation
21134
bio website
location
age 25
visits member for 3 years, 8 months
seen Oct 27 at 5:50

Web/print designer with an affinity for coffee, bubblewrap and Pokemon.

I don't fancy myself an academic nor an Excel guru. I just happen to really like Excel and use it for virtually almost anything.

Oh and I'm exactly 0.955224 smoots tall.


Aug
10
revised Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
added 144 characters in body
Aug
9
revised Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
added 663 characters in body
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
I'll update my answer shortly to help you parse the time string. You'll need to add a space between the time and the AM/PM notation. Then use VALUE to let Excel interpret it as a time.
Aug
9
answered Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Aug
9
answered Photoshop text spacing issue
Aug
8
revised Split a string in a cell in Excel using numbers as the divider
added 44 characters in body
Aug
8
comment Split a string in a cell in Excel using numbers as the divider
After pressing those keys, the formula should get enclosed in braces ("{ }"). That's how you can tell it's been entered as an array formula.
Aug
8
comment Split a string in a cell in Excel using numbers as the divider
First, copy the formula, then paste it into the formula bar. Instead of pressing Enter like you normally do when entering data, press Ctrl+Shift+Enter altogether.
Aug
8
answered Split a string in a cell in Excel using numbers as the divider
Aug
6
answered Excel conditional formatting of row
Aug
2
revised How do increase row height in excel by X. ie. Add verticle cell padding
added 54 characters in body
Aug
1
comment How to sort an Excel spreadsheet columns by row contents?
+1 I learned something new today!! :)
Aug
1
comment How can I dim my computer screen beyond the minimum?
I see. The icon looks looks like a black box. When I ran it the first time, the icon was hidden. I had to set it to "Only show notifications." I wish there was a better app though. But I guess it still helps keep eyestrain at bay for me for a while.
Aug
1
revised How do increase row height in excel by X. ie. Add verticle cell padding
deleted 34 characters in body
Aug
1
answered How do increase row height in excel by X. ie. Add verticle cell padding
Aug
1
revised How can I dim my computer screen beyond the minimum?
edited body
Aug
1
comment How can I dim my computer screen beyond the minimum?
That's why it's called a portable app. It doesn't install.
Jul
31
comment How can I make lined paper using Microsoft Word?
To help with manually creating the lines, toggle on the gridlines in View > Gridlines
Jul
21
revised How can I take hundreds of smaller images and create one big tiled image?
added 378 characters in body
Jul
21
answered How can I take hundreds of smaller images and create one big tiled image?