slot

I am creating a booking system with the logic of slots availability But when I select the slot from the gallery it doesn't fill the form I already input Gallery.Selected also tried with LookUp('Data Source',ID=Gallery.Selected.ID) and it doesn't work either

Where Z=length of string. Z can be 0 to 8. Each byte of the string will be a number between 0 and 9. I couldn't use a numeric field because 00100 becomes 100 and 00000001 becomes 1. The text string must have 1 byte for each time slot. I referee basketball. There are between 0 and 8 games in a...

Attempting to create a spread sheet that can calculate the number of minutes an operating room is used on a given shift. I thought I could save a great deal of time by asking here first. An operating room has a certain number of rooms it can use during given shift. So, if I have time period of...

Hello Everyone, Good Evening. I have the following table. <colgroup><col><col span="7"></colgroup><tbody> Shift Monday Tuesday Wednesday Thursday Friday Saturday Sunday 14-May-18 15-May-18 16-May-18 17-May-18 18-May-18 19-May-18 20-May-18 23:30 - 9:30 1 1 1 1 1 0 0 1:00 - 11:00 2 2 2 3...

hi, I will like to do an advanced filter so that I can spot duplicate.First, let me go through my sheet first. I creating a shet for the user to make a booking for their the slot. 1. First user input the start time of the appointment at V3 2. the total hours of the booking at V5...

Hello, Trying get my head around if there is any option to resolve below issue within formula or there is no other way than VBA. I'm trying find next available slot based on the certain criteria that times don't overlap each other. End Result <tbody> Time Room1 Room2 Room3 Room4 Room5...

Hello, I have a booking slot system with slot times 0600 - 2000. there are 53 in total and I want to copy the data into an excel file and have a pivot show the percentage of slots filled. Each slot filled with have a 5 digit reference number entered and empty slots will just be blank. Is...

hi guys, Need your help i have you help with a formula i need to populate a calendar according to a table that i have. at the moment i was able to do it for the time using the below formula...