Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 158811 times)

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12104
  • Total likes: 2156
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #1000 on: July 19, 2017, 06:24:09 PM »
i am trying to add up hours using =TEXT(G27-F27, "h")
is it possible to add a few times slot like 8-10 AM 2-4PM it gives me a error when i try
=TEXT(G27-F27,I27-H27, "h")or things similar
TIA
How about
Code: [Select]
=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")
Workflowy. You won't know what you're missing until you try it.

Offline bermo

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Feb 2014
  • Posts: 1548
  • Total likes: 17
  • DansDeals.com Hat Tips 11
    • View Profile
Re: Excel Problem
« Reply #1001 on: July 19, 2017, 06:39:28 PM »
How about
Code: [Select]
=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")
Thanks that was simple.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12104
  • Total likes: 2156
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #1002 on: July 19, 2017, 06:46:01 PM »
Thanks that was simple.
my pleasure
Workflowy. You won't know what you're missing until you try it.

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3307
  • Total likes: 517
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #1003 on: July 19, 2017, 07:54:34 PM »
How about
Code: [Select]
=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")

No need to double up the formula (I assume, haven't tested yet):

Code: [Select]
=TEXT(G27-F27+I27-H27, "h")

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12104
  • Total likes: 2156
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #1004 on: July 19, 2017, 08:07:02 PM »
No need to double up the formula (I assume, haven't tested yet):

Code: [Select]
=TEXT(G27-F27+I27-H27, "h")
good point
Workflowy. You won't know what you're missing until you try it.

Offline Jkhein

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Oct 2010
  • Posts: 4538
  • Total likes: 13
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Problem
« Reply #1005 on: July 20, 2017, 12:36:58 AM »
Is there a way to have a link to a product (eg. on home depot website) and the other column should retrieve the product picture from that page?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #1006 on: July 20, 2017, 04:09:57 AM »
Is there a way to have a link to a product (eg. on home depot website) and the other column should retrieve the product picture from that page?
https://superuser.com/questions/52760/embed-pictures-from-web-by-url-in-excel-spreadsheet-or-oo-calc

Yeah

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1007 on: August 15, 2017, 11:09:37 AM »
Going crazy here.. I use filters alot... when I click the dropdown on a filter, it only stays open for two seconds and then closes, and cursor jumps to random cell?! what is going on? tried restarting PC etc

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12104
  • Total likes: 2156
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1008 on: August 15, 2017, 11:51:13 AM »
Going crazy here.. I use filters alot... when I click the dropdown on a filter, it only stays open for two seconds and then closes, and cursor jumps to random cell?! what is going on? tried restarting PC etc
Is this only one spreadsheet, or all?
If you turn filters off and back on does that fix it?
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1009 on: August 15, 2017, 12:08:34 PM »
Is this only one spreadsheet, or all?
If you turn filters off and back on does that fix it?
All and no doesn't help...

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12649
  • Total likes: 7333
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1010 on: August 15, 2017, 12:21:16 PM »
All and no doesn't help...
maybe try turning off/disconnecting mouse and keyboard separately and testing then.
Feelings don't care about your facts

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12104
  • Total likes: 2156
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1011 on: August 15, 2017, 12:36:54 PM »
All and no doesn't help...
Do you have any macros in personal.xlsb? Maybe one of them is misbehaving.

You can also try uninstalling/reinstalling microsoft, but maybe that should be a last resort since it's a project.
maybe try turning off/disconnecting mouse and keyboard separately and testing then.
Good idea!
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1012 on: August 15, 2017, 04:16:41 PM »
Do you have any macros in personal.xlsb? Maybe one of them is misbehaving.

You can also try uninstalling/reinstalling microsoft, but maybe that should be a last resort since it's a project.Good idea!
Had some macros.. deleted em all.deleted personal.
Changed mouse and keyboard.
Repaired office.
Aghh. Still acting up

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12104
  • Total likes: 2156
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1013 on: August 15, 2017, 06:03:24 PM »
Had some macros.. deleted em all.deleted personal.
Changed mouse and keyboard.
Repaired office.
Aghh. Still acting up
Oy! I think I'm out of ideas then.
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1014 on: August 18, 2017, 12:12:52 PM »
excel 2016 - how to switch sheet from right to left to left to right??

Used to be under page layout, simple button. - Now even google doesnt know!?

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12649
  • Total likes: 7333
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1015 on: August 18, 2017, 06:35:10 PM »
excel 2016 - how to switch sheet from right to left to left to right??

Used to be under page layout, simple button. - Now even google doesnt know!?
Do you have hebrew installed as an input language?
Feelings don't care about your facts

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1016 on: August 19, 2017, 09:23:35 PM »
Do you have hebrew installed as an input language?
Probably not...

It's a standard feature in Excel. Switch whole sheet direction. Cell a1 on right. Just can't find it in 2016..

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12649
  • Total likes: 7333
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1017 on: August 19, 2017, 09:38:50 PM »
Probably not...

It's a standard feature in Excel. Switch whole sheet direction. Cell a1 on right. Just can't find it in 2016..
It only shows up with a right to left language installed. If you go to the customize ribbon options you will see it greyed out under page layout tab.
Feelings don't care about your facts

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1018 on: August 19, 2017, 09:40:17 PM »
It only shows up with a right to left language installed. If you go to the customize ribbon options you will see it greyed out under page layout tab.
Oh.. I'm actually using a laptop instead of my regular pc.. I guess I have to install Hebrew thx

Offline Thingywingy

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2011
  • Posts: 4602
  • Total likes: 26
  • DansDeals.com Hat Tips 24
    • View Profile
Re: Excel Help and Problems
« Reply #1019 on: August 25, 2017, 05:26:44 PM »
I applied shading to alternating cells as described in this Office support page. but for some reason the shading does not appear when I print? Any solutions?

I opened the page setup window from the page layout tab, went to the sheet tab and the black and white in the print section is not checked. I saw that online as a possible reason...
« Last Edit: August 25, 2017, 05:38:18 PM by Thingywingy »
I am sometimes accused of overthinking things. I am still mulling over whether that accusation has merit.