437 reputation
414
bio website
location
age
visits member for 4 years, 9 months
seen Jun 9 at 9:12

Sep
1
awarded  Notable Question
Jul
12
awarded  Popular Question
Jul
2
awarded  Curious
Jun
7
awarded  Excavator
Jun
7
awarded  Yearling
Jun
7
revised How do you open the Developer's Console on Chrome on an iPad?
Added info about mobile device emulation which is immensly useful and will likely work for the OP's needs.
Jun
7
comment How do you open the Developer's Console on Chrome on an iPad?
Also be sure to check out mobile device emulation in Chrome 32+ via sitepoint.com/use-mobile-emulation-mode-chrome
Jun
7
suggested approved edit on How do you open the Developer's Console on Chrome on an iPad?
Dec
20
comment How to merge (and not replace) folders when copying on the Mac?
Shouldn't have to hold down option to get the prompt, but it's still better than the other solutions, given that it's built-in. Thanks for adding this here!
Mar
3
awarded  Popular Question
Nov
1
awarded  Nice Answer
Feb
16
awarded  Notable Question
Aug
10
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Awesome, thanks for that. The only issue is it doesn't work past 24 accumulative hours. Any thoughts on how to overcome that? I was thinking that at least there might be a dd format specifier (dd:h:mm:ss), but it failed to work. Other thoughts?
Aug
9
awarded  Yearling
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Also curious... I can do TEXT(B2+B3, "h:mm") to sum up the total with your calculated output, but I can't do TEXT(SUM(B2:B3),"h:mm") because it just outputs 0:00. Any idea how to work around that issue?
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
I just noticed that, after implementing the SUBSTITUTE functions around each LEFT/RIGHT call, this formula doesn't work for pm-to-am timeframes... intriguing.
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
One last bug I noticed: 8:30am – 12:00pm calculates to 15:30! Did you catch my last comment about including the shorter formula as well? Although, that one doesn't work for pm-to-am timeframes. :\
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Aha! I pasted in the wrong rows! In any case, since you found out that wrapping the LEFT/RIGHT statements in the SUBSTITUTE calls works (instead of having to wrap each call to B2 with them), I'll mark this as the answer if you edit your answer to include the shorter, more readable formula (in addition to the longer more complicated formula, of course). After all, you have less points and worked harder at this! ;)
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Ah, nice! Yeah, I decided to shake things up at the last minute... but sometimes I do wish I could mark more than one answer as correct!! I think in general I would take an understandable solution over a "black magic" solution, but I give you kudos for showing off, Excellll! :P
Aug
9
comment Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Heh, the update is even longer! Still more bugs though: 2:30am – 3:00am calculates to 1:00, 4:00am – 7:00am calculates to 1:00, 9:00pm – 3:00am calculates to 1:00 in one instance and 0:30 in another. What's up with that?! :P