day

Hello forum friends, okay, here is an interesting one, at least from my perspective. I have been trying to come up with a formula that will look at two columns and return the difference between the odometer readings 'finish' from one day and the 'start' from the next day. This amount would be...

I want to create a chart that has columns for days of interest (like a time line) I don't care what the Y value is, just so that the column goes to the top of the chart on a specific date. So the X values should be dates from 1/1 through 12/31. The Y value is just a marker that moves from left...

Hi I would like to be able to subtract a combination of hours, minutes and seconds from a date and time. The resultant time may be in the previous day and that is where the problem is. For example : 10/08/2019 01:08:00 I would like to be able to subtract 1 hour and 15 minutes from this...

I have looked and tried, and no luck. I need A3 to do 2 things When the arrival date is less than the number of days allowed to turn red. so it will turn red when a date is entered and also turn red automatically using today's date. A1 has arrival date A2 Has drop down list with 1 day, 3...

Hi there I am trying to create a macro/code that will overwrite data each day when a new file arrives I have a spreadsheet that has a daily forecast for the next month where each day has 48 half hours/rows and 28 columns (including the column for the date/period i.e. dd/mm/yyyy hh:mm). This...

Hi all, I'm hoping that someone can assist me with this! I have an Excel file located on my C drive C:\Users\Barry\Concessions\Concessionsregister.xlsm There is an access database in the same location C:\Users\Barry\Concessions\ConcessionsDatabase.V1.accdb I have a data connection in excel...

If I have a date in Cell A1 and I want to get the start date of the next week, how is that possible? So: A1 shows 7/26/2019. I want B1 to display 7/29/2019 (week begins on Monday). I know it is some combination of WEEK and DAY but not sure how to do it.

Good Day :) I have to calculate the per day amount for a project and put it in a report showing it on an annual basis. My issue comes if the project starts mid of the month, i need a formula to determine the date from project start to year end and calculate per day rate. Eg: Project Start...

Every day, I export data from an external database and paste into Excel. From there, I run a macro cleaning up formatting and removing bad data but the number of pages varies day to day and the page break always causes a few blank pages to print. How do I input code into my extant macro so...

Hi all, I've managed to stump myself on what should be a fairly simple task. I have a data file with activity by time for employees. Each action has a time next to it. I'd like to create a chart that visualizes the breaks between actions so that one can see for example that someone took a...

Hi All, I have a problem with the line chart i,e I am unable to show the data by week wise but I can able to see by day wise. Please help me to show the data by week and day wise like the below screen shot. Please check the my output: I used my order data for my axis and I can see by...

I have a sheet that i have columns numbered 1-31 (Days of the month). i have another sheet that has a cell with a Today() formula. when i activate the macro i want to get the day of the month from the Today() cell and based off of that day i want to add a number underneath the corresponding day...

Any good way to get Last Month as a month number using today's date? Previously I've done =NOW()-32 and that seems to work, but without figuring it out you could run into a day in a month where this fails? Like the first day of the month would take you back 2 months until you hit the 2nd or 3rd...

Hi! I need a formula or something that will calculate a ship day of the week without using an actual date. For example, my scenario is this: x load is delivering on a Monday. The transit time from origin is 3 days. What day of the week did the load ship? The answer would be a Wednesday (don't...

Good Day Mam/Sir. In this project , i have to register for an appointment. Sample picture below. as of now, i am managing to save the inputs from userform to worksheet. to finish my project, i just want to add a code that limit the applicant to register for a specific time in a specific...

Hello to everyone, I was wondering if there is any VBA code or Conditional Formatting for changing the Fill Collor of a cell after I wrote in it. The trick is that I want this to work with a timer. What I mean is that at midnight the cell to become filled with red color and after I wrote...

I am trying to find a way to compare some line graphs. The data will be in 3 columns, B Date, C Time, D Result. There are 288 samples taken per day, but the data may not start at midnight and go until midnight when analyzed. Maybe the first sample when a file is opened is 9am, and from then a...

Hello I would like to be able to keep track of the allotted hours remaining for particular tasks. We use a workbook for each day, emailing the time sheet to our main office. I enter the hours spent on a task and they are subtracted from the budget hours. The next day I 'save as' the previous...

Hello all! I have a spreadsheet at work that the techs enter in on/off times for equipment. I need to know how many hours the equipment has ran that day. <tbody> Date Initals OFF ALL DAY? ON ALL DAY? INITIAL SHUT DOWN INITIAL START UP SECONDARY SHUT DOWN SECONDARY START UP 5/1/2019 BB...

Hello, I am looking to add cell values together, i keep having the value column, an e.g. of what i am trying to add below: <tbody> Cell Person Day 1 A1 User 1 10 A10 User 2 0 A16 User 3 Sick A84 User 4 Pto A101 User 5 9 A122 User 6 12 </tbody> I am trying to add the amount sold...