daylight

  1. J

    Removing non-duplicates

    I have an Excel sheet with names, emails. I also have a list of emails from a CMS and want to cross-reference. I want to remove all email addresses that are NOT on the CMS list from the Excel list. How would one go about doing this? I am a total newb in Excel. Thanks so much! Just to clarify I...
  2. S

    simple "AND" issue

    Good Afternoon, I'm having an issue- I think I've coded "AND" wrong. Right now, with today's date and time, the sheet is kicking a "No" when it should be "Yes" and changing the computer date to December (to see if it says "Yes") doesn't change away from "No" so I figure my use of "AND" was...
  3. M

    how to find and sum together all the variables in a table as they relate to daylight hours and night hours

    I have a csv file of consumption data recorded every 30 mins for 365 days. How would I write a formula to find all the variables that fall between say 6am and 6pm (daylight hours) and 6.30pm to 5.30am (night time hours)? Ideally I would like a total of consumption during daylight hours and...
  4. J

    Time zone conversion

    Hi guys, I've been Googling this and can't seem to find an appropriate answer. What I am looking is for a way to bulk convert Times from Pacific Timezone (PST/PDT) into local UK time (GMT/BST). So what is needed to be known is whether the date is in Daylight Saving Time for one or both of the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top