range between two feilds

  1. E

    Calculating hours/minutes between time ranges

    Hello all, I'm in dire need of finding a better solution to this problem: I am in need of caclulating the time between multiple time ranges. Time Range A is a recurring schedule for the month of November, that allocates specific time slots to users, who are then allowed to login during these...
  2. E

    Calculating the hours/minutes time ranges do not overlap

    Hello all, Hopefully I can explain this clearly... I am currently trying to calculate the hours/minutes from Time Range A (which is a recurring schedule of APPROVED time ranges) that do NOT overlap with Time Range B (which is a larger data set of different login periods). Basically, users will...
  3. O

    grab value from table with < > range

    Hi I have a table per below from which I would like a formula to grab the % value which corresponds to the Days e.g. I have another calc which provides me with 185 days. I would like to create a formula/adjust my table (whatever is necenssary) so that I can write a formula which will look at...
  4. S

    find where a number in a range of numbers is with formulas

    I have sessions ranges of time (ticketing sessions) Sheet 2 filed Gray i have also events in another file. I need a function that looks at an event time and dates and returns to me the corresponding session For example File 1 A FILE A Code, Sport, Date, Start time, End time of a session Session...
  5. C

    Vlookups and ranges

    Hi, I know this question has probably been posted 100 times before but here it is again. I have a tab called Lookups which contains the following table: <TABLE style="WIDTH: 154pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=205 border=0><COLGROUP><COL style="WIDTH: 94pt...
  6. P

    Select data contained within a symbol and move it to a new sheet

    Hi, What I'm trying to do is load a CSV file and split in onto multiple sheets based on a symbol i.e. Column A;Column B; Column C Date; Data; Data Date; Data; Data Date; Data; Data Date; Data; Data Date; Data; Data Date; Data; Data %% <---- See this and starts a...

Watch MrExcel Video

This Week's Hot Topics

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
Top