start

Hi I am Struggling to solve this! I need to calculate time between two dates, but need to be only between 8:00 AM and 5:00 PM, excluding weekends. I got some results, but when the start time is over 5:00 pm still add the time... example below: Start End Transmission time (h:mm) 28/09/2019...

Hello All, I thought this may be easy, but I'm finding it aggravating <tbody> Project Name Start Finish Project 1 11/16/19 3/15/20 Project 2 6/12/2019 1/14/2020 </tbody> I want to make a horizontal bar chart with a series name of the projects...

Hi, I am wanting to put together a spreadsheet that will calculate my pixel led lights into universes. Each Universe has 510 channels, each Universe increments by 1, you can hundreds of universes. Headings will be Channels used (A), start universe # (B), start channel # (C), end universe #...

I have a spreadsheet that logs the start and finish of a task... I want to get the total time between the start and finish row, the thing is that the rows are not continuous, column A/B and F would be my triggers I guess as column A/B are the employee ID and Column F is the "Start/Finish"...

Hello! I am looking for a formula that lists a new number ever time a new time would appear. For example (7:16, 7:16, 8:34, 9:25 = 1,1,2,3) the only problem is, i need this to start over every time a new day appears in another column. i hope that's clear and that someone can help.

I have a code that hides the ribbons on top of my excel sheet and the code looks like this. Private Sub Workbook_Activate() Application.ScreenUpdating = False Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" Application.DisplayFormulaBar = False Application.DisplayStatusBar = Not...

I have a worksheet that will most likely be used by two people (a couple) but could also be used by a 'single' (unmarried) individual. I'll try to explain my conundrum. Here goes... The worksheet contains a cell with the following formula and it works as intended but I would like to modify it...

Hello, I have been trying without any luck to find the time difference (Sun - Sat, employee start & finish times) between two columns of times, but the finish time may go into the next day. I found a post here that I thought might work, but VBA MOD is apparently different from Excel MOD. I...

I'm trying to do a calculation where time can be added but only adds within working hours & days. I found this calculation...

Hello, I am trying to jump columns in excel from a cell, could anyone help? I'm trying through For sub test () For i = 1 To 5 Cells (i) .Select Next i End Sub What I need is to start in cell A, then jump every 10 columns until it's over.

Hello, Quick question. I am looking to do a multiple IF AND statement including LEFT. The below formula gives me a #VALUE error so I know I am doing it incorrectly: =IF(AND(C2="Blue",(LEFT(D2,1)="C"),"250",""),IF(AND(C2="Blue",LEFT(D2,1)="B"),250,"")) C2 has to be Blue AND D2 has to start...

Hey guys, My assumption is that there has to be a better way. In my ListBox, I'm trying to get 3 column headers (DAY | START | FINISH) and also have the time displayed in the list as 10:00AM, as opposed to being a decimal (0.41666666), which is why I was trying "* 24" in the code. If anybody...

I've got a spreadsheet with a hidden 'start date' column. The start date is going to be the same for all tasks that are inserted into the sheet, so I want it to automatically fill this date in when people insert a new row. Is this possible??

i can't seem to get my head around this formula. i have a range of project data where each record has start, end, and change dates. Some of these records begin prior to the start of the financial year and some start within the financial year and then end after the end of the fin year. The change...

So I have thousands of rows of data every day. In column F I have an event code and in column G I have the duration of that event. I need to know if "Event B" occurs within 20 minutes of "Event A". If F2 is "Event A" and G2 is 0:09:23 and F3 is "Event X" and G3 is 0:00:03 and F4 is "Event Y"...

Column X contains a list of all companies. Column Y is used for a simple check (values would be yes, no, n/a) In column Z I have a partial list of company names. Here is what I need help with: I need to start at Cell z2 see if that value matches ANY value in my column X Range (x1:x1000) If yes...

<tbody> a b c d e 1 1 2 =B1+1 3 =B2+1 4 =B3+1 5 =B4+1 6 7 8 9 </tbody> Hello All! I was wondering if someone could help me with a formula to cycle back to the number 1 after it reaches a limit of 83. I was using the formula above, but when it...

Hi I have a spreadsheet that contains among other columns, 2 columns. They are start time and end time. Their format is 7/1/2019 2:17:11 AM for example. Of all the start times, I want to ONLY retain the information where the start time is */*/2019 21:00:00 PM and the end time is */*/2019...

Hi there, I've tried to recreate two tables which I'm working with below: <tbody> Start Date Finish Date Effective Days Total Amount Daily Amount Month Start of Month End of Month Monthly Amount 04/09/2019 22/10/2019 49 1000 20.41 Sep-19 01/09/2019 30/09/2019 ??? 15/09/2019 15/10/2019...

Hi, I'm looking for a simple formula that will calculate the difference between a start and an end time then subtract 30 min. So, for example, the start time is 7:00 am and the end time is 4:00pm. I can calculate the time difference but I don't know how to then modify the formula to subtract...