Time Calculation
i have two date/time fields
sdate (start date) 01/01/2006 14:30 - format(dd/mm/yyyy hh:mm)
edate (end date) 02/01/2006 14:31 - format(dd/mm/yyyy hh:mm)
i need to get answer in HH:MM (24:01)
pls help me
thnx best regards
ibu
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Time Calculation
i have two date/time fields sdate (start date) 01/01/2006 14:30 - format(dd/mm/yyyy hh:mm) edate (end date) 02/01/2006 14:31 - format(dd/mm/yyyy hh:mm) i need to get answer in a textbox as 24:01 (hh:mm) pls help me thnx best regards ibu
View Replies !
View Related
Time Calculation
Hi all, I'm a beginner, and i want to know how to calculate time difference. For ex, if i substract 23:45 of 02/09/2006 with 00:10 of 02/10/2006 then i get a - "ive" value... Please somebody help me with a vba code for this... thanks Senthil.
View Replies !
View Related
Time Calculation
Can someone please help me as this is driving me crazy and I know the answer must be simple. I have a query/report that shows the duration a call has taken i.e. it times each part of the call. For example it may take a member of staff 00:00:30 to answer a call, then he puts a customer on hold whilst he speaks to another department which could be another 30 seconds, and then he ends the call with the customer. So my report and query shows: Ringing 00:00:30 Speaking to customer 00:04:10 On hold 00:00:30 Ends call with customer 00:02:00 The duration of the action is in a seperate column. How do I tell access to add these up so I get a total of 00:07:10 for the entire call from start to finish? Thanks for you help Rich
View Replies !
View Related
Time Calculation
I am struggling with a filter I thought would be simple. I have a field called close time and I want a filter that will show a record one hour before the close time?
View Replies !
View Related
Time Difference Calculation
Hello: I have a report with three text boxes: Box 1 contains an employee's total weekly hours in hours and minutes: 40:00 Box 2 contains the actual total hours worked for the week: 35:30 Box 3 is the difference between Box 1 minus Box 2 I tried all the date/time functions to calculate the difference between Box 1 and Box 2 and none of them worked. I keep on getting an error message. Does anybody know how to calculate the difference between two sets of time (in hours and minutes)? Thank you in advance.
View Replies !
View Related
Date Time Calculation
Hello friends, I have a table for "Production Orders" ie. work orders. there are feilds : start date , start time based on these feilds i want to calculate the remaining time to start production. but what i want is if remaining time is > 1 day then give results in the format " 1 day and 2 hrs" elseif remaining time < 1 day then give result in the format " 2 hrs and 24 mins" and also current time - remaining time > 0 else result = "N/A" how can i do this simply
View Replies !
View Related
Date / Time Calculation Help
I'm having trouble getting my head around this. I have a database that collects stats of patients admitted to ICU. I have a table PtDataTable (pk = PtID) with a one to many relationship with PtVisitTable (pk = VisitID, fk = PtID). The patient visit table has the fields AdmissionDate and AdmissionTime, and DischargeDate and DischargeTime. I need to calculate if the patient is readmitted to ICU in less than or equal to 48hrs. In other words calculate the time elapsed between DischargedDate and DischargedTime in one record and the AdmissionDate and AdmissionTime for other records in the PtVisitTable for the same patient. I'm not sure if I stated this clearly. Any help is appreciated as always.
View Replies !
View Related
Date & Time Calculation
Table ------ I have one field called [Time] in dd-mm-yyyy hh:mm format in table A. I have another field called [Deadline] in text format (Mon 10:00) in table B. Queries ------- Need to build one queries that have the above two field, but with additional field called [PullDeadline] that the [Time] will look out the [Deadline] and return the actual time & date value in [PullDeadline]. No matter how the [Time] change, the [PullDeadline] will stick to [Deadline] and return the value in that particular week. For example, [Time] = 01-12-2007 05:00:00 AM [Deadline] = Mon 10:00 [PullDeadline] = 26-11-2007 10:00 AM How to handle, if the deadline is previous or next week? Eg. [Deadline] = Sun 10:00 Then [PullDeadline] = 25-11-2007 10:00 AM instead of 02-12-2007 10:00 AM.
View Replies !
View Related
Time And Date Calculation
OK so I have a form with the following fields which are all date/time type apptTime timerOn pickupDate reminder - combo box with 1 hour, 2 hour...etc up to 10 hours so what happens is when user enters apptTime say 18:30 with pickupDate set for current days date 10/14/2006 then chooses 2 hours from the reminder combo. This then sets timerOn to (apptTime-2 hours) so it is 16:30. I have set a conditional formatting to change background color when "timerOn<=Time() and pickupDate=Date()" so user knows to dispatch this load. This all works great until you get to midnight. If user sets apptTime to 00:30 with pickupDate to 10/15/2006 and chooses 2 hour reminder, so timerOn does get set to 22:30 and you would expect the conditional formatting to work once the current Time() is 22:30, but since the current Date() is 10/14/2006, the expression is false. I have tried the DateAdd such as DateAdd("d", 1, Date()) command in various ways but can't get it to work for "timerOn<=Time() and pickupDate=DateAdd("d", 1, Date())"...I mean it works because it adds 1 day to pickupDate and condition is then true, but it ignores the timerOn<=Time() part and formats even if I reset system time to 22:29. Can anybody give me insite on where the logic is wrong?
View Replies !
View Related
Need Help With Time/ Hours Worked Calculation
Hi Guys I need to create a method of calculating -week number,hours worked per week and a leiu hours total. Explanation Users enter their worked hours per day. I need to calculate the total hours worked per user per week and if this is greater or less than their contracted hours a record of this figure over a continual time period (or year). Variables :- Time worked,Holiday hours,Leiu hours taken,Sick leave, Other authorised leave. I realise that i'm asking on a lot but working for a charity has financial limits. Attached the basic database-so far Thanks in advance for your help Row
View Replies !
View Related
Date And Time Format Calculation
Hi, I need to calculate the number of days between two days however the format on which i have my date includes the time in the same field - 2007-02-20 07:15:30.474 When I calculate one date minus an other the result is #error I require the result to be in a count format e.g 2.3 days (like in excel) Is there anyway to get around this without splitting the date and time? Please help!:)
View Replies !
View Related
Time Varable Used In Formula Calculation
Please advise how I can incorporate a time variable (in elapsed minutes) in a formula and have it update automatically every minute: example: count the number of minutes elapsed from a point in time multiplied by a fixed rate (such as Gallons per minute) to produce a value of gpm over a period of time. Any suggestion are welcome. Stinhop
View Replies !
View Related
Interesting Time Calculation Problem
i need to calculate time, the problem i have is that we are trying measure production over the day, however our days run from 22:00 through to 22:00 the following evening i have tried to calculate it by taking the end time from away the start time, but when i tried to do this it gives the wrong figure eg DayCode - 3111 (This is just the code we use to represent each day) Line - C3 ( Machine identification) Start Time - 22:00 ( Time the Machine started) End Time - 18:00 (time the machine ends) Duration - 04:00 (the figure that is display when calculated in access) the duration figure should be 20:00 hours i have managed to get it to work upto a point with the following code runtime: IIf([starttime]=[endtime] And [starttime]=#22:00:00#,#23:59:59#,IIf([starttime]>[endtime],(#23:59:59#-[starttime])+[endtime],[endtime]-[starttime])) but if the the two times are the same for example 22:00 on the first evening through til 22:00 the following evening, i should get a result of 24 hours but instead i get zero, so i was wondering if there is a work around to this problem, i also need the time to be displayed in full hours whereas the above code only dislpays it to the correct hour minus 1 second. i have attached a sample for you to look at: i hope this makes a little sense. thanks Andy
View Replies !
View Related
Time Format - Short Time Displayed As Medium Time
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network. The link works fine but the time formats are different. On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM# Weirdly though, when you just open the table, the times are in the correct shorttime format. Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances? Any ideas? This screen shot may help:
View Replies !
View Related
Time Format - Short Time Displayed As Medium Time
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network. The link works fine but the time formats are different. On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format However on PC 2, opening the same database via the network, the time format is still short time but the format is in AM/PM or medium time. Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances? Any ideas?
View Replies !
View Related
Calculating The Total Time Of All Recorded Time (MS Access 2000 And 2003)
Hello, Here I am having a little bit confusion about how to calculate the total time of steps of a process (for example: registering a new user for a website) in MS Access: - step1: entering a user name in a text box will take 00:00:10,94 - step2: entering a user password in a text box will take 00:00:03,12 - step3: entering a user confirmation password will take 00:01:30,16 - step4: entering a user email address in a text box will take 00:00:07,79 so, the total time of each step will be 00:00:52,01 the idea is that I have two fields in a table named "Total Time". the first field i named it "Process Type", where I type each step of a process as I mentioned above. And the second field I named it as "Timing", where I type the time manually for each step. in a form, there will be a control source "text box" that will calculate or sum all time that are in the "Timing" field which are listed manually by me. I need a solution of it, because it is my first time to deal with this concept????
View Replies !
View Related
Having A Combo Box With A Time Greater Than The Previous Recordset Time.
I am currently trying to have a subform which has a start time and a end time in each recordset. My problem is I want the end time to only give out values greater than the start time. Im using a combo box to look up values in a table, and then a query in the end time box to look up values greater than the start time. This works fine in the first record, but in the second record the end time is only greater than the start time of the previous record NOT the the current record. How can I set it so Record 2's start time choice starts greater or equal to the previous records start time and the end time is greater than that records start time? Thanks for your help.
View Replies !
View Related
Ignore Time In Date And Time Field
Hi, Wonder if someone can help please. I'm quite new to Access so please bear with me. I have a data field in my database consisting of both a date and time. I then have a form containing two fields where the user can type a 'To' and 'From' date to extract the records that they are interested in. The query behind this uses the 'Between[Enter The Date] And [Enter The Date]' coding. The problem is that because the field contains a time it doesn't return any records when I run the query. Can anyone offer a bit of guidance on how I could ignore the time part of the field perhaps by adapting the above. Many thanks Chris
View Replies !
View Related
Time Management - Simple Time Clock
Hi all, I havent' been around in a while (toddler, work, getting my BS degree and new baby coming in a week and a half) so I am hopefully not asking a previously posted question. I'm suspecting my new work isn't accurately paying for the hours worked. I made a quick simple DB where I input my punch times in short time format. There's the typical In, Out for Lunch, In from Lunch, and Out. I've got it correctly adding the times so that it reports the total hours worked per day, though, in order for it to display correctly, that total is in short time as well. The problem is, when I group a week together, as soon as the sum of the totals reaches 24 or more, it goes back to 0, as it's on the idea that there's only 24 hours in a day. Hopefully, it's just a formatting issue or is there a function to convert the times (or just the sum) to number of hours? Thanks and Happy New Year to all. -Jim
View Replies !
View Related
Hard Code TIME To Selected Date On Form (to Make It Date&time) For My Query Criteria
Hello buddies :D, do you have any idea how to make this work? To select data that falls within this criteria of date range between cboDate and cboDate2 (fields on my form). The date in [tblJobDetails]![timeIn] come in this format "08/17/06 10:24 AM", but the cboDate/cboDate2 (takes in date only e.g 08/17/06) what i am after is to evaluate specific hard coded time in addition to the date entered, i.e. even tho, i haven't entered time on the cboDate/cboDate2, I want specific time hard coded where e.g If i select a date range of 08/17/06 and 08/18/06 on my cboDate and cboDate2 it should really be evaluating: 08/17/06 8:00 AM to 08/18/06 8:00 AM. This is the criteria i curentlly have on my query in design view tha works perfect in selecting date only. ([tblJobDetails]![timeIn]>=[Forms]![frmPendingJobs]![cboDate] Or [tblJobDetails]![timeIn]>=[Forms]![frmPendingJobs]![cboDate] Is Null) And ([tblJobDetails]![timeIn]<=[Forms]![frmPendingJobs]![cboDate2] Or [tblJobDetails]![timeIn]<=[Forms]![frmPendingJobs]![cboDate2] Is Null) How can I incorporate 8:00am to 8:00am into my cboDate and cboDate2. What can i do to make this happen? Your kindness will be greatly appreciated http://www.naijaryders.com/forums/images/smilies/thankyou.gif
View Replies !
View Related
Time In Access: Keeping "medium Time" Format
I've run into a bug, I think. I have a time field with it set to show "Medium Time" which is "hh:mm(AM/PM)", however, when I combine the information with another field in a query (=[OfficeDay]&" - "&[POfficeTime]), the time comes out as "Long Time" or "hh:mm:ss(AM/PM)". End result is Wednesday - 10:30:00AM when it should be Wednesday - 10:30AMDoes anyone know a way around this?
View Replies !
View Related
IF Then Calculation
Trying to calculate a few fields. 1st field is [delays] and 2nd field is [Planned] The Plan scheduled for 60 and the Delays are an entered value. In the on update command button on the form I want code that will take the value above 60 and add then to the value in the [Delays] So if delays is 10 and the planned is 70 then planned will change to 60 and delays will = 20 any help Jon
View Replies !
View Related
Q:Calculation
Hi All. I have 3 tables in Access: tblCurrency (Fields: IDCurrency, CDate, CRate) tblOrder (Fields: IDOrder, OName, ODate) tblCalculation (Fields: IDCal, Rate1, Rate2, Rate3, COrder) IDOrder is related to COrder with "One to Many" connection. I have Form frmOrder, based on tblOrder. For Example Form has 1 record: IDCal OName ODate 1 XXXX 2005.10.24 For this record related table has 2 records: IDCal Rate1 Rate2 Rate3 COrder 1 10 3.5 15 1 2 6 4.2 12 1 tblCurrency for Exapmle have one record too: IDCurrency CDate CRate 1 2005.10.24 0.2 In frmOrder I have textBox txtRate. Here I need to be calculated: =Sum (Rate1*(CRate from tblCurrency Where tblCurrency.Cdate = tblOrder.Odate)+Rate2*Rate3 for Each record related to tblOrder). By Exapmle: (10*0.2+3.5*15)+(6*0.2+4.2*12)=106.1 Please help with expression. Thank You in advance.
View Replies !
View Related
Calculation
I am trying to do this calculation but it doesn't work. It is yielding a negative number when the day_of_wk - "2". Can someone help? Thank you. pre: IIf([day_of_wk]="1",([time]-[reg_time])/60,IIf([time]<0,([time]-[reg_time])/60+24,IIf([day_of_wk]="2",([time])/60,IIf([time]<0,([time])/60+24))))
View Replies !
View Related
Need Help With Calculation
hey i hope some one can help me... I am making a database for products and suppliers. Many suppliers can supply each product. The product details are in a table called products, the suppliers details are stored in a table called suppliers and the suppliers offer for each product is stored in a table called prices. the structure is as follows: Table: Products Product Name Trade Price Table: Suppliers Supplier Name Table: Prices Product Name Supplier Name Supplier Offer I have form that shows the product details and a subtable linked to the table:prices. The problem I need to add a field in the subtable called "Percent off trade" which is the trade price - supplier price / trade price * 100 i created a query showing the same records as the prices table plus the field "trade off price" and set the Field to: Percent Off Trade: ([Forms]![Products]![Trade Price]-[Prices]![Supplier Price])/[Products]![Trade Price]*100 But this doesnt give me the correct percent :confused: I hope i have explained this query and would really appreciate anyone who takes the time to suggest anything that could help thanks in advance!
View Replies !
View Related
Calculation
How can I multiplicate two numbers from two columns in a subform, show their result at the end of the row and then calculate sum of those results on the main form. This is something what I know how to do but the problem is following: The total sum on the main form should be multiplicated wit 0,5 % and then reduced for a value of a specific row sum. It should be something like this: (Sum of rows sum * 0,5 %) - Sum of the specific row = Total sum on the main form. And all of this should be on a report too.
View Replies !
View Related
What Calculation To Use?
What would I use for a formuls to find all product that are in stock. like I have a price for all products that i stock, but some i don't have in stock. How would I query for the ones that I have in stock? In my table I have it as UnitsOnHand, I have it as how many, like 1 or 3 or 4 etc. And also a field for Paper or Metal. How would I query just for paper and not metal? I am also going to need a query for the lowest price and the highest price. Please understand I am New and I have allready search through all the post and can't seem to find anything close to what I am trying to do. Any and all help would be great Thank You WackoWolf
View Replies !
View Related
|
TRACKER
