User Profile
csmythe101
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Issues with Time Comparisons *First Time Excel User*
I'm going to try to make this as short as possible. I am trying to make an excel sheet for me to use at work that will help greatly with day to day tasks. I have spent the last 10 hours searching google and speaking with an AI to help make the sheet I need. I know basically nothing about excel so I heavily relied on the AI, although it seems to have worked well so far. I can't tell how much progress has been made, as I don't know what all needs to be done, but I feel like I'm at least 50% done?. What I'm trying to do: Make a sheet that will filter the information of facilities I work with, the corresponding days and times that I work them, and have it compare the current date/time on my computer to the time ranges given for the corresponding day for all facilities, and automatically compile a list of which facilities I will be working with at whatever time it is. The time range can vary heavily from day to day (however the weekly schedule stays the same) so there are many cells with different time ranges. There are 41 different facilities (technically 39, but 2 of the facilities have a certain department that has their own times, so I just made a row for them as well) What I've done: -Column A is the list of facility names -Columns B-H list days of the week (S-S), -Column I has 4 cells (1 for the current date/time generated by my computer, 1 for the current day it is [don't remember why this was added], 1 for current time [again, don't know why this was added], and 1 which I'm TRYING to get to compare the current time against the time ranges listed for each day at each facility. I cannot for the life of me figure out why I'm having an issue with the time comparison. I spent so many hours with this AI trying DOZENS of different formulas and manual fixes to get it to work, and it just won't. Eventually it said "Sorry, I'm out of ideas, go contact someone else". So here I am. Tried Solutions: Closing and Re-opening app, trying formulas in the web-version, quick repair, verified region info, verified formatting for time ranges, verified spelling, no extra spaces, no hidden icons, verified correct category for each cell. I'm happy to give formulas used for each cell if it helps. Just please help me Column883Views0likes4Comments
Groups
Recent Blog Articles
No content to show