Help with time.

How do I sum the amount of  time on a report if timein is 7:42 AM and
timeout is 12:33 PM. Is there a easy way of doing this?


10/17/2007 2:07:54 AM
access.reports 4434 articles. 0 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 19

Time is stored as a number. You can add times like you can add numbers. You 
can also use one of the many date/time functions like:
   DateDiff("S", [EarlyTimeValue], [LaterTimeValue])
The "S" gives the time in seconds. You can use "n" for minutes as well as 
many other intervals.
In a report or group Header or Footer, you can use a control source like:
   =Sum(DateDiff("n", [EarlyTimeValue], [LaterTimeValue]))
This will return the Sum of the time duration in minutes between a the time 

Duane Hookom
Microsoft Access MVP

"Floyd Forbes" wrote:

> How do I sum the amount of  time on a report if timein is 7:42 AM and
> timeout is 12:33 PM. Is there a easy way of doing this?
> Thanks 
10/17/2007 4:20:00 AM
Floyd Forbes wrote:

>How do I sum the amount of  time on a report if timein is 7:42 AM and
>timeout is 12:33 PM.

Assuming the time in and time out fields in the table
include the date, then use text boxes in the report footer

txtMinutes text box:
	=Sum(DateDiff("n", TimeIn, TimeOut)

txtHoursMins text box
	=txtMinutes \ 60 & Format(txtMinutes Mod 60, "\:00")

MVP [MS Access]
10/17/2007 4:37:03 AM

Similar Artilces:

Vb code working one time
Hi, I have a form for adding data to a table. In this form , there is a command button for adding those data and it has the following code: Private Sub Command22_Click() On Error GoTo Err_Command22_Click If IsNull(Me.Combo28) = True Then MsgBox "You Must Select a S.O.Processor First.", vbCritical, "No Processor Selected..." Me.Combo28.SetFocus ElseIf IsNull(Me.CONTRACT_NO) = True Then MsgBox "You Must Input a Contract No. First.", vbCritical, "No Contract No. Input..." Me.CONTRACT_NO.SetFocus ElseIf IsNull(Me.CONTRACTOR) = True Then ...

Conditional formatting help
Hi, I can't figure out the way I should create this conditional formatting. It's probably very simple though. If a cell, let's say J5, is empty for three days, then the background of cell A5 turns red. Any help would be appreciated Thanks Any 72 consecutive hours? Starting when? What if someone entered something then deleted it an hour later? Would that re-start the three day period? You would need some type of event code to watch J5 to reset the counter in that case. I don't think it is "probably very simple" but I may be over-reading this or you have ...

Help with CTabCtrl
Anyone got a link (or something) to some code which shows how to use a CTabCtrl? In essence I'm trying to nest CPropertyPages -- a CPropertySheet with a number of pages, each with a number of pages below it. For some reason I just can't get my mind around how to do this. The "right" way seems to be: CPropertySheet CPropertyPage some displayed data and some CTabCtrls... and so on. But I just can't get how to insert a control into the CTabCtrl... Thanks for any help. "Frank Hickman" wrote > Take a look at the attached'll...

Every time I open Microsoft Excel or Word my system crashes. Can.

Need help!
Hello, I need help. I generate charts, using macros, for my company. The macros are a fast tool when you have to do 40-50 charts a project. Well, my company had changed colors to the charts. As a result, I'm responsible updating the macros. Unfortantely, I'm not familiar with visual basic. The person who created the macros left the company. Can you please take a look at the excel files? Hopefully, this makes sense. Any suggestions and solutions are fully welcomed. Thanks in advanced! link: e-mail: ...

Multi-value paramter
How do I write the syntax for a stored procedure that has one parameter but accepts multiple values. I am running a report from reporting services that can pass multiple values or pass all values to the stored procedure stored procedure 1: exec getcolor @color = blue....this runs fine. stored procedure 2: exec getcolors @colors in('red', 'white', 'blue').........bombs code is create procedure getcolors @colors nvarchar (50) as (select * from hrs_by_activity where color in(@colors) ) need help making this work. thanks in advance O...

Help with Business Portal Instalation
Hello, good afternoon group I have a problem, when i'm trying to install the Business Portal, the program checks the requirements shown me that everything is fine, but the button NEXT does not enable me to continue, which may be happening? I need your help, please. Thanks, Yandy ...

Macro Help
I'm a complete newbie when it comes to macros. H I J K 422 11 2.0 1.6 0.40 423 5 4.0 3.5 0.50 424 7 6.0 4.0 2.00 I highlighted this group of numbers in my spread sheet from H422 to K 424, and then I recorded a macro to sort on column K from highest to lowest. When done it looks like this: 7 6.0 4.0 2.00 5 4.0 3.5 0.50 11 2.0 1.6 0.40 I want this macro to work for every group of numbers like this throughout the spread sheet. Not all at once, but one at a time as I need them. So if I go d...

HELP ! Windows Server 2003 SP2 boots indefinitely
Hello, Since the last Microsoft Update (last week) two of my servers Windows server 2003 SP2, where the update was accepted, boot and reboot indefinitely. The other servers Win 2003 which didn't accept the update are running fine. How can I get rid of this last update ? Or can we correct this awful bug? I need your help ! Thanks You can uninstall it from the recovery console. From the recovery console command line navigate to; %SystemRoot%\$NtUninstallKBxxxxxx$\spuninst where xxxxxx is the KB article number you want to uninstall. and execute BATCH spuninst.t...

Need stacked chart help
Hi All, I have a problem with a stacked chart in excel 2000, i have used th search function but could not find a solution. The problem is as follows: I want to create a chart with one stacked bar (consisting of variables). And i also want another stacked bar (consisting of 2 variables). Only the proble is that there is a big difference in the numbers so one hardly shows up. Now i want both bars on different scales. Can somebody help me ? Thanks in advance -- wjvivee ----------------------------------------------------------------------- wjviveen's Profile: http://www.excelforum....

conditional formatting with FORMULA... Please HELP! #2
Hi all, I have price data in rows like this (each price takes up a cell): 5 5.43 6 6.25 6.50 8 15 9.25 9 8.75 8.50 8.50 8.50 8.50 13 I need to show trends via conditional formatting where on 3 or more consecutive days prices fluctuate EQUALLY by 0.25 or more each time, up or down... IE, with the above data, I would want to "flag" let's say, in red fill color, the sequence 6, 6.25, 6.50 as well as the group 9.25, 9, 8.75, 8.50, but NOT the group of 8.50, 8.50, 8.50. I have tried if/and/or statements again and again and come close on simpler tre...

Adding Time Format
I am adding time for a day and would like the total to be returned in a different format. If I needed the time between 8:30am and 12:00pm added up it displays 3:30 as my total. How do I have it display 3.5 as the total? Currently the total cell is formatted [hh]:mm. Thanks for the help. you need to do something like this A1: 8:30 AM A2: 12:00 PM A3: =(A2-A1)*24 and then format A3 as a number. "jtinne" wrote: > I am adding time for a day and would like the total to be returned in a > different format. If I needed the time between 8:30am and 12:00pm added up > i...

Help me make a timesheet?
Hi, I want to make a simple spreadsheet to keep track of times when I work from home. I can add and subtract in time units, but what I now want is to add 2 macro buttons which when clicked will insert the current system date and time into the next empty cell in the column (let's start at B2 for ease of explanation, so the second click of hte button will insert into B3, then B4 etc) One button will mark the start of a work session, the other will mark the end. Thanks for any assistance. -- Regards Jon Hi Jon, Are you aware that you can simply select the cell and then Ctrl+Shft+...

Help! Navigation bar disappeared after re-publishing!
I did some modifications on my navigation bar and re-published the entire website. When I reviewed my site, I noticed that the navigation bar was gone. I called Hostmonster who hosts my website. They uninstalled and re-installed the FrontPage Extension twice and renamed the access file, and each time I re-published the site. But to no avail. Does anybody have an idea? I am at my wit's end. Monika If you have a website give us a link to it so we can it and help you Out? "yogalady" <> wrote in message news:1B6DDF78...

Excel Help....
I am trying to populate a spreadsheet with multiple information. I have a listing of counties that I want a single cell to identify (maybe a drop down?)in an already populated worksheet. Then I want the cell for "tax" to automatically populate the tax code associated with that county with the county entered. Can anyone help.... Hi use Data - Validation and VLOOKUP. See: -- Regards Frank Kabel Frankfurt, Germany "Jen" <> schrieb im Newsbeitrag n...

I have already done the regedit Level1Remove. Most everything works fine. My problem is that when I try to open an attachment that is a .jpg it wants me to save each individual file to disk before I can open it. I receive enormus amounts of jpegs a day and need to scan through them quickly without saving them. PLEASE HELP TO BYPASS THIS PROBLEM!!!!!! ...

Help with InputBox and MsgBox
I want an InputBox and MsgBox to display several lines on text and want to be able to hit carriage-return so that the text reads like a paragraph. I have the following :- Title = "Please Enter Password to LOCK ALL the sheets" MSG1 = ("Enter Password and Select OK") resp1 = InputBox(MSG1, Title) How could I format the above to say have a carriage return after "Enter Password"? -- Thank U and Regards Ann MSG1 = "Enter Password" & vbCr & "and Select OK" vbCr is a "constant" and is the same as Chr(13) which is th...

Help with tax formula for marginal tax rates
I am trying to make a single formula that will calculate a person's taxable income assuming the six different marginal tax rates that range from 10% to 35%, as income increases For a single taxpayer, the marginal tax rates and the associated income amounts are: 10% up to $8,350 15% up to $33,950 25% up to $82,250 28% up to $171,550 33% up to $372,950 35% over $372,950 I am using "IF" statements to test for each marginal tax rate. I began the formula as follows, but it returns a value error. Cell D36 is the taxpayer's income =IF(D36<=8350,D36/...

Help on Queue
Hi, Can someone explain me and help me out about how to get the queue system working? im not getting it... * When i try to send a email to: <-- this didnt work out... the email dont get on the queue to assign later on... in the email router i have estabelish a rule for to the crm user that have the queue... * When i try to send a email to:; <-- this works .. the mail gets in the user queue and is assigned to my user... * if i try send a email to ; th...

Help: Messages Disappear from Inbox Current View is set to Message
Hi: We are using Outlook 2002 SP2 and XP Pro SP1. Messages are disappearing from my inbox. I checked google and MS knowledge base. The current view for my inbox is set to message and not unread messages. The only other twist is that I have two accounts one is a pop3 and the other is imap. These accounts have two separate inboxes in their own folders. Any suggestions, TIA, Mariela I would double check your rules to make sure people are not being added to your junk senders list by accident. Dave >-----Original Message----- >Hi: > >We are using Outlook 2002 SP2 and XP ...

Loan help
I am getting a loan that will be put into my checking account for my use however I want. There is no asset as colateral. I will just be recieving cash. I cannot get Money 2003 to create a loan that deposits money into my account. Do I just have to create a deposit into my checking account? The thing I don't like about that is money treats it as an income with a category when it is really more like a transfer. The budget and net worth features don't work correctly like that. Just create it as a deposit. I know what you mean about it being treated as income, but it is, althoug...

Attachement Issues
Please help: I am running Outlook 2002. When I send email with attachments the email does not move from my 'Outbox' to my 'Sent Items' folder, causing the email to be sent multiple times. This does not happen with normal emails. My recipients are receiving multiple copies of the same email and I have no idea what the problem is. Any assistance is greatly appreciated. Jeremy. Does this still happen when you disable the outgoing virusscan? -- Robert Sparnaaij [MVP-Outlook] Tips of the month: -Backup and Restore -Create an Office XP CD slipstreamed...

Help with Debt Reduction Planner
OK, first, I have to say that getting help from MS is absolutely horrid. This should be MUCH more convenient than it currently is. When I bought this program, I was told I'd have unlimited access to help. Little did I know how hard it would be to find. OK, on to the problem: When I put a debt in the debt reduction planner, it lets me set the payment I want to make every month and I can flip back and forth between when I want to pay it off and how much I want to pay. However, when I go to see the payment schedule, it automatically adds $1,000 to the first monthly payment I h...

Recipient policy help
Hello, I am trying to create multiple recipient policy's for our company. We have many domain addresses because of mergers, so we want the divisions to retain their smtp name space. The odd thing is I create a custom recipient policy point it to a group i.e. domain1all through the Advanced modification. Well it updates the SMTP domain for all the users within this group but it also did all mailbox enabled objects. Can someone point me in the right direction? Also does it need to be a group that I point it to? Or is there a way to do an OU? Thanks, Jeremey Hi Jeremy, Unfortun...

help needed with outlook 2000 email
I cannot send or receive email on my outlook 2000 account. have used it for years but now it is caput. error message reads: A TCP/IP error occurred while trying to send data to the server. (Account: ‘’, SMTP server: ‘’, Error Number: 0x800ccc13). Help would be much appreciated. Thansk you. Orlando coalcorona <> wrote: > I cannot send or receive email on my outlook 2000 account. have used > it for years but now it is caput. error message reads: > A TCP/IP error occurred while trying to send data to the...