Excel Help and Problems

[etech0]

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")

[bermo]

How about

Code: [Select]

=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")

Thanks that was simple.

[etech0]

Thanks that was simple.

my pleasure

[skyguy918]

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")

[etech0]

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

Code: [Select]

=TEXT(G27-F27+I27-H27, "h")

good point

[Jkhein]

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?

[churnbabychurn]

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

[churnbabychurn]

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

[etech0]

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?

[churnbabychurn]

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...

[aygart]

All and no doesn't help...

maybe try turning off/disconnecting mouse and keyboard separately and testing then.

[etech0]

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!

[churnbabychurn]

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

[etech0]

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.

[churnbabychurn]

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!?

[aygart]

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?

[churnbabychurn]

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..

[aygart]

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.

[churnbabychurn]

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

[Thingywingy]

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...