how do i add time up in exel

everytime i use  =sum(a1:a30)*24 i keep getting an odd number even though i 
only enter even numbers ,this is to add my hours worked in a month 
0
loadie (1)
4/26/2005 1:38:05 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
461 Views

Similar Articles

[PageSpeed] 14

Tell us what's in a1:a30. If they are all even numbers, you should 
definitely get an even result. But if they include minutes, you can get an 
odd number of hours.

-- 
Regards,
Fred
Please reply to newsgroup, not e-mail


"loadie" <loadie@discussions.microsoft.com> wrote in message 
news:12306C49-050C-4DED-AD75-2ECEE54A24F7@microsoft.com...
> everytime i use  =sum(a1:a30)*24 i keep getting an odd number even though 
> i
> only enter even numbers ,this is to add my hours worked in a month 


0
fredsmith99 (155)
4/26/2005 2:09:45 AM
Hi

type out a sample of 5 of your numbers and what you get when you add them 
and what you expect.

-- 
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"loadie" <loadie@discussions.microsoft.com> wrote in message 
news:12306C49-050C-4DED-AD75-2ECEE54A24F7@microsoft.com...
> everytime i use  =sum(a1:a30)*24 i keep getting an odd number even though 
> i
> only enter even numbers ,this is to add my hours worked in a month 


0
JulieD1 (2295)
4/26/2005 11:56:19 AM
Reply:

Similar Artilces:

Unable to add OWA account to outlook 2007
Hi! I've got a university OWA account that I want to use outlook 2007 with. I can't manage to get it working, it's come up with various messages, such as outlook has to be closed to add email accounts and that it cannot connect to the server. Here's the info I can find on my OWA account: Mailbox owner: [xxxx.xxxxxxxxx@students.plymouth.ac.uk] User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2) Gecko/20100115 Firefox/3.6 Outlook Web Access experience: Basic User language: English (United Kingdom) User time zone: Exchange mailbox address:...

Display and calc of time formatted colum
Errr. I need a bit of help from someone please. I'm using Office XP and in Excel, what I want to do is create a column of time(s). The time is displayed as - mm:ss:xxx - so that e.g. 3:29:917 (means) 3 min, 29 secs, and .917 of a sec A. Is the format achievable as a display and if so, how? B. Can the numbers be aggregated (summed) Hi Bazza! Format mm:ss.000 But watch your data entry is 00:03:29.917 You can aggregate in the normal way =A1+B1+C1 However, if you don't want minutes to change to hours after you get to 60 use: [mm]:ss.000 Similarly if you don't want hours...

can you not add calculated fields in SmartList?
Hello: Can you not add calculated fields togather in SmartList? childofthe1980s I don't know for sure, but I seem to have a vague recollection of having a problem with that, too. Can you get around it by doing something like so: A = some field * .5 B = another field * 1.5 C = A + B (but this doesn't work) Instead of C being calculated as A + B, could you make C = (some field * .5) + (another field * 1.5)? -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 "childofthe1980s" wrote: > H...

Formatting Negative times
I'm trying to display the difference in the amount of time I exercise from month to month. Sometimes, it's negative. using a formula in EXCEL: =IF(AND(ISNUMBER(Q3),ISNUMBER(C3),C3>0,Q3>0),IF((T3-F3) >0,TEXT((T3-F3),"m:ss"),TEXT(-(T3-F3),"-"&"m:ss")),""), it works fine (the cells are in excel time, days). When I write a macro to do the same thing using: Cells(r, SumTAvgCol + DColD) = Format(-a, "-" & "mm:ss") I get -12:26. Always 12 as the minutes. If I use: Cells(r, SumTAvgCol + DColD) = Format(-a, &q...

How To Add Streaming Video to your web-page
Adding Streaming video to your web-page is as simple as a few clicks of the mouse with this amazing tool. http://www.ebvalues.com ...

How to add Opportunity link to workflow email
Hello, how could I add link to Opportunity, when sending email from workflow. Example: I reassign Opportunity to other user and workflow sends email to him and informs about new opportunity assigned to him. How to add hyperlink to email ??? I use MS CRM 4.0 B.I. On 2 Lut, 13:07, "B.I." <aid...@jdjdjd.lt> wrote: > Hello, > > how could I add link to Opportunity, when sending email from workflow. > > Example: > I reassign Opportunity to other user and workflow sends email to him > and informs about new opportunity assigned to him. > How to add...

outlook wants to install every time
OK, here is the deal: I installed office costumized, Run All From My Computer, and configured Outlook by pointing to the exchange server. Works fine. I restart the pc and logon with a different username and start Outlook. Now Outlook asks for the CD! Why? I previously said "Run all from my computer". As this pc will be used by many people who have no local administrator rights I do not want to spend time on giving them those rights and handing them the cd. Please tell me what I can do (during installation?) to prevent outlook from ever asking for the CD again, when a new user wants ...

Is there a way to delete multiple lines at the same time beside u.
Please let me know if there is other ways to delete multiple lines at the same time without using the Ctl key. Thank you. Hi Cherry are the lines adjacent to one another? if so just drag down the row numbers and then right mouse click & choose delete .. .if they're not adjacent and you don't want to use the Ctrl key to select them, how are you going to identify which rows you want to delete? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "cherry" <cherry@discussions.microsoft.com> wrote in message news:4BD...

Exel Blue Gradient Service Quote
I am using Exel, and I downloaded one of the service quote forms (Blue Gradient). I am attempting to create a quote for a job, and I have used all the available cells and I need it to roll over onto a second page. If anyone has an idea of how to do this, I would really appreciate it! Help me please "Kev" wrote: > I am using Exel, and I downloaded one of the service quote forms (Blue > Gradient). > I am attempting to create a quote for a job, and I have used all the > available cells and I need it to roll over onto a second page. If anyone has > an idea of how ...

Gift/Bridal registry add-ons???
Does anybody know of any Gift/Bridal registry add-ons that are out there? I will need reseller pricing,as we are an RMS dealer in Canada. Tony, Try this; http://www.obsol.com/html/gift_registry.html -- * "Tony Cormack" <TonyCormack@discussions.microsoft.com> wrote in message news:779434E4-2FE1-4ED9-854B-48347C92A2A5@microsoft.com... Does anybody know of any Gift/Bridal registry add-ons that are out there? I will need reseller pricing,as we are an RMS dealer in Canada. Thx Jeff, thats what I had found also "Jeff" wrote: > Tony, > > Try this; > ...

How do you get Signatures to be in the email all the time?
Hi, I have a simple question. I have been using Windows Mail Desktop for awhile. I love it, except for two things. The one problem I have is when I am on the internet and there is a link to an email, if you click on it it brings up a window for sending an email. My signature does not show in that. How do I get it to show in that? I looked at all the options and I didn't see where I could do that. My sigature only shows when I click new messages, or replying. Not when I open up an email window from a link on the internet. How do I do that? Also, I asked this before but ...

VBA: Cannot add fields using Shift F11
Hi: I am trying to add fields to a window where the menu bar is not available. Although I can add the window with a keyboard shortcut (CTRL-F11), the fields shortcut that is supposed to work (SHIFT-F11) does not. I am on GP9.00274 on XP against SQL2000. Anyone else run into this? Dwight -- All: Found the problem. I had the ScriptDebugger=True line in Dex.ini set. The debugger uses Shift F11 to turn on the debugger so it was not allowing the VBA shortcut to run. Dwight "Dwight Specht" <Dwight_Specht@hotmail.com> wrote in message news:eLeOtnGIHHA.1188@TK2MSF...

Time clock on Headquarters
Hi, Does anyone know how we can check the timeclock (punch in / punch out) of the employees from the Headquarters Manager? Thank you! Rami Hi, if u have access on Microsoft customer source go to this link and u will find your required report https://mbs.microsoft.com/customersource/support/downloads/reportslibrary/rms/ModifiedReports/modifiedreports_rmsheadquarters.htm just copy it and drug it in hq folder reports. "Rami" wrote: > Hi, > > Does anyone know how we can check the timeclock (punch in / punch out) of > the employees from the Headquarters Manager? >...

How to add streaming video to your website
www.abcsun.net > >para recibir solo en castellano como tengo que hacer "Mike" <info@abcsun.net> skrev i meddelandet news:OURGuUwvJHA.5584@TK2MSFTNGP04.phx.gbl... > www.abcsun.net > ...

how do I automatically add incremental numbers to a cell
Hi! I'm a bit thin on information, but have a look at Edit > Fill > Series Al -- Alf ----------------------------------------------------------------------- AlfD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=478 View this thread: http://www.excelforum.com/showthread.php?threadid=26940 ...

Recipient Policies and Add Button
When making a new policy with Mailbox Manager Settings, there is an ADD button under the (Policy) tab. Feels like you can click it and add folder names to be managed exclusively. But it seems to do nothing. Can someone explain what the button is for, and if it is for adding a specific folder, what is the syntax to do so? From KB http://support.microsoft.com/default.aspx?scid=kb;en-us;278024 "Additional folders can be added based on the users' mailbox root folders. Mailbox Manager can operate against folders that users have added, provided that the folders match exactly. The ad...

Macro to add numbers to create combinations that equal certain amo
Thank you for your assistance. I receive a list of numbers, usually over one hundred items. I need to find out which amounts will add up to a given total. How would I create a macro to do this? Is there already an Excel function to do this that I have not found? It would need to work with currency. Ex: 9, 12, 7, 4, 15, 8, 10, 3 total needed 18 Solution 8+10; 3+15 Lauren, With a hundred different items, there are over 2^100 possible ways to combine them. You would need a supercomputer - or maybe even multiple supercomputers. If you had fewer than 25, you could do it. HTH, Bernie...

Show more time in weekly view?
Outlook 2007 On default the weekly view is only showing until 4 PM without scrolling down. I know there is a way to let you see into the evening hours also without scrolling. Help please. Thanks... Bob ...

why won't excel allow me to add more data to a chart?
For some of my data I skip days for collecting it so I use the shift key to click on the days I do want in the chart. I have been doing this for awhile but now that I'm obtaining more points it has simply stopped letting me add data points. When I click on the one where it stops collecting it erases all of the others I have clicked and makes a stop noise. I need to add more data so why won't it let me?? Hi, There is a finite limit on the length of the series formula, ~1024 characters. So this example is for a series with 3 data points in cells A2:B4. =SERIES(,Sheet...

Allow only one user to access workbook at a time
I need to set excel to allow only one user at a time to access a workbook. The workbook is NOT a shared workbook, but it resides on a network share. Multiple users need to access it, but only One at a time. I want all other users to get a message that the file is in use and they can not open it. Is this possible? I believe that is the standard behavior of a network file that is not shared; users who access the file when it is in use get a message the file is in use and whether they want to open as Read Only. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "Emir_of_sh...

Same Worksheet Opens Every Time Workbook is opened
I created a two worksheet workbook. The first worksheet acts as a very simple welcome page - a graphic an a button. when you click the button, you are brought to the 2n worksheet which is filled with info. I would this 1st worksheet to open up as the first page every time. So, even if some edits the file, and saves changes. When it is opene up again, this welcome worksheet is the first page seen. Is this possible? P.S. (I do not know VB. I've been copying code from this for verbatumto use in my projects...which works out nicely thank you. -- Message posted from http://www.ExcelForu...

Trying to add all together
This is the formula I am trying to use to add a column and a single cell together. =SUM(K58+S2:S34) It does not work. How do I change it? AuntieAnnette Hi =SUM(K58,S2:S34) -- Regards Frank Kabel Frankfurt, Germany "Auntie Annette House MO" <anh650t@swbell.net> schrieb im Newsbeitrag news:eLKx0Kd7EHA.3756@TK2MSFTNGP14.phx.gbl... > This is the formula I am trying to use to add a column and a single cell > together. =SUM(K58+S2:S34) It does not work. How do I change it? > AuntieAnnette > > Thanks I appreciate the assist. SOoooooooooooooo Simple. It...

"Save As" dialog taking a long time to display
Most recently, in trying to save a Word document using the "Save as.." dialog, it took several minutes to display the dialog box. All the while, the SPOD was spinning away in Word. I could use other apps, even other Office apps (Entourage, Excel), but not Word. Is this a known problem (hopefully with a known solution)??? Mark Office 2004 11.2, OS X 10.4.3 P.S. I just noticed it's a problem with the "File, Open" dialog as well, in Word, Excel, and PowerPoint. But once I've used either one of the dialogs, there's no delay using either one of them afterwards du...

add 3-d style in Publisher 2002
I am using Publisher 2002. I want to use the 3-d style. I select the image, select the 3-d on the toolbar, the drop-down window displays with the 3-d styles..... The styles are disabled. Appreciate assistance as to why this function is not working/enabled. THANK YOU. larry 3D will only work on simple shapes such as auto-shapes or text boxes. If you have a .wmf image you can ungroup it and 3D the parts. You can do some interesting things with the shadow settings, especially raster images with transparent background. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer....

I know this quesion has been asked a million times but.....
the answers that I have found havne't worked. It's simple. I have query that has a date field. I have a form with two unbound tex boxes, one called txtstartdate and txtenddate. I also have other text boxes that work. One allows you to enter a location, and the other allows you to enter a customer. They are and/or. You don't need one to search by the other, but you can search by both if you want to. The code for the startdate and enddate txt boxes is: Between Forms!QBF_Form!txtStartDate and Forms!QBF_Form!txtEndDate It does not filter for a date. What am I doing wrong. Wha...