range between two feilds

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

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

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

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

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

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