Adding Multiple Times Together Not Working Correctly

Jun 10, 2013

I have a list a time (HH:MM:SS) that i want to sum together to get the total number of minutes.

It works if I use simply add A2+A3+A4 etc, but not when I use sum(a2:a4).

There are over 2500 lines of data.

Sheet attached : times.xlsx

View 3 Replies


Command Button Not Working Correctly?

May 1, 2013

I have a command button on my form that unloads it when i am finished. But i have to press it 20 times before it closes. The only line i have in the code is "UnLoad Me"

View 7 Replies View Related

Filtering By Dates Not Working Correctly?

Jun 26, 2014

[Code] ....

In column F I have a list of dates (dd/mm/yyyy).

I can manually filter dates ok, but want to set it to part of code to use automation for a report.

The code when run, finds nothing, where it should. I tried using [CDate] also but also same result.

View 3 Replies View Related

Auto Sort Not Working Correctly

May 12, 2006

I'm try to get the pos. placing in a auto sorted table to remain in place
i.e. 1st next to the top position. 2nd next tothe next position and so on down. but it keeps getting it wrong! I've tried amending the macro serval times but it makes things worse! Sorry can't attach the file, too big for this forum!!!!

View 2 Replies View Related

Selection Change No Longer Working Correctly

Apr 11, 2007

This vba code is supposed to move the cursor to the Cacluate1 command button when the user clicked on cell H6.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$H$6" Then Calculate1.Activate
End Sub
The only changes that I have made is a change to a private sub worksheet_change(ByVal TArget as Range). Would these changes have anything to do with this no longer working?

View 9 Replies View Related

Index Function Working Correctly When Hit F9 But Returns Different Result

Aug 22, 2012

I'm compiling a list of names on a separate tab from a column that only lists the names sporadically. Problem: In the formula, the IF provides a TRUE, the row function, and consequently, the INDEX function (when I hit F9) provides the correct "name" and row number, but when I hit return, it provides the text 4 cells beneath what it should.


View 7 Replies View Related

Math Mystery- Not Adding Three Numbers Correctly

Oct 10, 2008

I am having an issue with Excel not adding three numbers correctly.

C10 = .82
C11 = .18
C12 = .70

C14 = Sum(C10:C12)

I also tried C10 + C11 + C12

Excel keeps telling me the answer is 1.69!

View 9 Replies View Related

Formula Not Adding Correctly, Calculate The Results Based Off Of What Is Shown In The Cell

Apr 9, 2009

Basically a cell might have a number with 3 decimal places

For Example 90.554, and i will format the cell two 2 decimal places. But when i use those cells which are formated to 2 decimal places in a formula it produces results based of all the decimal places in that cell.

Is there a way for the formula to only calculate the results based off of what is shown in the cell? . This is messing up our accounting area by alot of dollars since we sell many items.

I included an example of what i mean in this excel file which should clear up any confusion.

View 2 Replies View Related

Times Sheet Working Am To Am

Jul 29, 2006

I am trying to do a basic time sheet for a friend and i know NOTHING about VBa so dont use it..

I simply want to work out how many hours someone works and was going along nicely until someone work over 12 hours.

I have
Start time end time hours worked

I formatted the boxes for hh:mm and the formula was end -start (easy)

then someone started at 8am and worked right throught to 5:30am and i get the answer as -2:30 but it should be 21:30

View 9 Replies View Related

Only 1st Condition Of Multiple IF Conditions Evaluates Correctly?

Jan 23, 2014

I have 4 conditions in one formula, and only the first condition (when met) evaluates correctly. When the other conditions are met, I get a VALUE# error.

I want to concatenate 2 cells, based on whether there is an "a", "b", "c", or "d" in a particular cell. see example. Below is my formula:


View 6 Replies View Related

Summing / Adding Times

Apr 29, 2009

I've been trying to figure out a way to sum up a column of times like this (please see attached portion).

Right now, all the cells on the worksheet are formatted as text, and the "total" is actually a text value, not a formula.

I've tried converting all the cells from text to numeric, even tried custom formats like [h] to no avail.

What is happening for me is that when I try to sum up a column to get a total, the value gets converted or rounded off to zero (usually like 0:00.00).

View 14 Replies View Related

Adding/Subtracting Times

Sep 8, 2009

I'm making a table for myself to keep an eye on my hours worked every week. What i want is to be able to enter the start time and the end time and for Excel to find the time difference inbetween (not numerical mathematical difference) also i need to subtract a half hour from the time entered for monday thru thurs.

View 2 Replies View Related

Adding Times In A Row Of Cells

Nov 20, 2009

I am trying to add a ROW of times. Each cell of times is using the 00":"00 format so I don't have to type a colon between the hours:minutes.

I'm not sure of what the formula should be for the Total Hours box.

For example, if I were to type 13:45 in the start time & 14:00 in the end time, I am getting a result of 0:55 which is incorrect

Another example if I leave the first 2 start/end boxes empty(blank) and then type 15:30 Start & 17:00 in the second set of Start/end boxes, I get a Total Hours of 1:70 which is also incorrect.

The formula I have in the Total Hours box is =SUM(B12-A12)+(D12-C12) which is know is incorrect.

What is the correct formula which will give me a Total Hours which adds a row of times correctly?

StartEndStartEndTotal Hours

View 9 Replies View Related

Adding A Column Of Times

Aug 10, 2006

I have several columns of times in the HH:MM.SS format. I need a sum at the bottom of each column.

If I put a Sum or a Cell+Cell formula in, it gives me the #value error. I've tried a few different things but can't get it to work.

Could someone be so kind as to tell me the formula or point me to the instructions for this?

(The data reflects times spent on certain tasks for each day, and I need a sum at the end of each column giving me a total amount of time spent on that task for the month.)

View 4 Replies View Related

Adding/Sum Times: Add 8min34sec, 1hour12min40sec And 45min58sec

Aug 11, 2006

Which cell format i have to use to be able to add time? For example: I want to add 8min34sec, 1hour12min40sec and 45min58sec.

View 3 Replies View Related

Adding HH:MM:SS Not Working

Feb 18, 2009

I have a column with hours in the following format HH:MM:SS, that looks like this:


I am trying to add the sum total of all hours, but its not working. I have my column formatted as time -> 37:30:55

View 6 Replies View Related

Number Of Working Hours Between 2 Dates Including Start And Finish Times

Mar 22, 2007

I have 2 dates+ times.

1 the contract start date and time.

2 the contract end date and time.

Can I calculate the number of working hours between these two using a formula?
So if I have a 10 hour working day (08:00-18:00), Mon-Fri and the two Dates/Times can I calculate the number of working hours?

Start 06-Mar-07 10:00
End 14-Mar-07 14:00

This is 2 part days and over a weekend.

View 9 Replies View Related

Adding Working Hours

Dec 18, 2009

I want to write a macro to add business hours to a datetime value, excluding weekends, non-working hours and holidays.

e.g., I have a value (datetime) of "18/12/2009 11:30:00 AM", I want to add 10 hours to this, so as to get the result as "19/12/2009 12:30:00 PM".

View 7 Replies View Related

Adding Rows With Control Number That Only Repeat 3 Times: Formula

Apr 1, 2009

I'll try to explain this the best I can. What I have here is a time study. Teachers (which are the control numbers) fill out bubble sheets, then I run them through a scanner. After dissecting the data from the scanner and formatting it to my liking i get this below.

Each teacher/staff member fills out three sheets per quarter. Each letter (bubble) counts as a 0:15 min period of time. Only K thru Q counts as billable time, which I've created a formula to count those letters (column 3). But to be countable each control number has to have three cycles 201,202,203.

So I need something that can take each control number that has three cycles and add their # of 0:15 together.

The italic row below only has one cycle for that control number, so that needs to be deleted or ignored.

Ultimately I would like the results on a separate sheet.

This is only a part of the file, there are over 1000 different control numbers.

View 14 Replies View Related

Adding Cell = Macro Not Working

Dec 9, 2008

I had a working macro before i added an extra row for another entry (No. of Hours spent). The entire data collection calculates the total price of a project (called PSR) in another cell underneath. The macro is suppose to move the entire data into another sheet to keep a history (in Sheet2). I've attached the file containing the workbook.

View 2 Replies View Related

Adding 7 Working Days To A Date

Dec 17, 2008

I have a worksheet where in column B I have a vendor name, column E I have a date value and in column AF I need to calculate a due date based on 7 working days for vendor A and 14 days (not working days) for vendor B. I've tried to write an IF statement but can't do it. Can anyone suggest the right combination of IF/AND statements that would do this? I attach the workbook should my useless attempt at explaining my problem be unclear...

View 3 Replies View Related

Conditional Formatting Stops Working After Adding Column

May 21, 2013

I have a conditional formula that highlights dates red when it meets a certain criteria. The file named MS Working, the conditional formatting formula (formula below) works as it should with no issues. The other file MS NOT Working, the conditional formatting formula (formula below) has stopped working as it should. What I did? I inserted a new column to the left. Where the MS Working file has only 1 column to the far left, the MS NOT Working file now has 2 columns to the far left.

It seems as if the formula adjusted itself when I inserted the new column; however, its not working.

MS Working
Conditional Formula: =AND(TODAY()>B3,NOT(ISODD(COLUMN())),B3<>"",OR(C3="",C3=0),B3<>0)

MS NOT Working
Conditional Formula: =AND(TODAY()>C3,NOT(ISODD(COLUMN())),C3<>"",OR(D3="",D3=0),C3<>0)

View 3 Replies View Related

Adding Date And Time Minus Not Working Hours

Sep 11, 2011

I have a data of complaints where I need to present it to the Management in such a way that the SLA period of 8 hours does not pass. Our office working hours are 7 AM till 7 PM. The complaint received should be escalated to concern section within 8 Hours of SLA time. I have the list of dates with received time. The complaint which could not be escalated today would be escalated next day. In this case is should deduct 12 Hours (7 PM to 7 AM, Non-working hours) from the time. How can I insert escalation date so as that it would deduct non working hours from it.

View 5 Replies View Related

Difference Between Dates And Times In Days , Hours Mins ( Working Hours )

Mar 2, 2010

The below formulae allows me to see the difference between two dates and only returns the difference in working hours ie :
Difference between
02/02/2010 08:00 & 03/02/2010 08:00 is 16 Hours 0 Minutes


The following displays it in the Hrs and Mins format

=TEXT(B15,"[h]")&" Hour"&IF(OR(TEXT(B15,"[h]")+0=0,TEXT(B15,"[h]")+0>1),"s "," ")&MINUTE(B15)&" Minute"&IF(MINUTE(B15)1,"s ",""))

View 9 Replies View Related

Adding Multiple Cells From Multiple Sheets With Sumif Function

Jan 20, 2009

I'm trying to put together a spreadsheet that tracks disc capacity increases, affected by any incoming projects. I've managed to do so for one project, but would like to for up to 10. The way i've designed the solution (i'm sure there are far more elegant ways, but hey) is thus:

A forecast worksheet keeps track of a grand total, taking information from sheets P1 -> P10 (being projects 1 to 10). I am unable to figure a way to add up all the increases from all 10 project worksheets with one succinct formula. What I use so far is: ='P1'!C83+SUMIF('P1'!E82,"=2009 - Q1",'P1'!D82) ..................

View 5 Replies View Related

Sum Times During Multiple Intervals?

Mar 18, 2014

I'm trying to determine how much time our agents are spending for their lunch/breaks during 30 minute intervals. Range A8:A200 lists the agent's names, Range B8:B200 lists their lunch/break start times, Range C8:C200 lists their lunch/break end times, and Column E lists the times (8:00, 8:30, 9:00, etc.). If an agent starts their break at 10:57 (Column B) and ends at 11:10 (Column C), the value next to 10:30 (Column E) would have 0:03:00 and the value next to 11:00 would have 0:10:00. But would need to sum all the agents which took a break/lunch between 10:30-11:00, and 11:00-11:30.

View 2 Replies View Related

Calculating Multiple In And Out Times

Apr 10, 2014

I would like to add up multiple time in and time out for my pay sheet.

As you can see, the total hours worked for Weed A is correct, but the Total Hours Worked for Monday is incorrect. The forumla I am currently using is:


But I would just like the total hours worked for each day to be the actual hours (2.5 hours).

View 2 Replies View Related

Run Code Multiple Times?

Jun 11, 2014

In this workbook Test1.xlsm under column "D" i have Po numbers. Some PO numbers are the same and some aren't. I have a specific code that creates an invoice for a customer when i hit the code however i must select a cell under column "D" in order for the code to create an invoice for the customer on that row. I usually create the invoice for all the customers of the same PO number. Sometimes the amount of invoices i have to create is overwhelming so i was wondering if it's possible that when i select a cell under column "D" that has, let's say, PO number "654" if the code can create an invoice for all customers that have the same PO number of "654"?

View 1 Replies View Related

Moving Nth Row Right And Up Multiple Times?

Apr 3, 2014

I have essentially the same issue with my spreadsheet, but mine is a little easier. I have written code to do the first few steps. I could just use some assistance with the middle. I know my thought on the process is "the long way", but with my experience in VBA I have to keep it simple. Here is my data and then the way I want it to look. I can add a macro to make it pretty afterwards, unless your way is easier (and I understand what is happening). --Oh, I am trying to automate my inventory process.

I have a spreadsheet and i wish to move every nth cell in column A to the initial cells in the row.

Cell A2 moves to E1
Cell A3 moves to F1

Until the end and then select all and sort by column B (this would get rid of blanks and sort everything) before moving to the pretty stage.

How the data comes in. And my Final Goal.

This document is several thousand lines long. I made up the data to protect the weak. There can be duplicate usernames and vendors, but never serial numbers and computer names. Duplicates should be highlighted to be found easily and researched.

I only need to get to the middle picture. After that I can modify with what I come up with.

View 9 Replies View Related

How To Get Values Out Of Column B For A Value In A (multiple Times The Same Value)

Mar 14, 2014

I have a excel sheet with several columns and 2700 numbers in each column. In the first column there is standing from witch quarter to witch quarter of the day the values are (and this for several days in one sheet). I want to take the average of all the first quarters of the day, the average of all the second quarters of a day,.... But if I would do that by just sorting my table on the quarters and than manually make the formullas I would need to give in 800 formules. (way to much)

So I would like to find an easier way to take the average of column B for the valeus were A is "00:00 -> 00:15" (this are avery time 28 numbers in the month february)

In attachement you can find an example of my problem, although it isn't with real values.

View 5 Replies View Related

Copyrights 2005-15, All rights reserved