Adding Time Durations

Jul 29, 2005

hi
i've got a time duration field that is formatted as a string. I want to be able to sum up the durations as i group the records in different ways. I can't convert it to time, because it changes the durations to a time value, not duration example: 12:29pm instead of 0:0:21
is there any possible way to work with time durations??

thanks
*j

View Replies


ADVERTISEMENT

Adding Up Durations (1.15 As 1h15m)

Nov 18, 2004

I have been asking this question couple of times but I don't think I am making myself clear. Here it goes again. I am tracking meetings that happend. With other fields, the meeting also has a "Duration "field. in that field how long the meeting lasted is entered. for example if it took 1hour and 15 minutes the user enteres 1.15.

Later, I have a report that displays meeting for selected dates. like the following

1/1/03 1.15
2/2/04 1.30
2/2/02 2.45

I want to add all the duration together for example if we add the above durations we get 5.30 or 5hr30min.
The way I have it not, it sums it up as regular numbers so it sums it up as 4.9

any suggestion would be appreciated.

View 2 Replies View Related

Adding And Subtracting Short Time Values Together/changing Short Time Into Minutes

Dec 9, 2004

Hello again,

I think my subject heading explains it. How would you add or subtract two short time formatted values and produce a short time value? Also, how would you change a short time value into number minutes. (i.e. 5:30 into 330) Thanks!

G

View 1 Replies View Related

Adding Minutes To A Time

Apr 20, 2006

Hi,

If I have a time like 22:00 and I want to add lets say 300 minutes to it; so it now shows 03:00 how do I do this? I can do it in Excel alright with the TIME function but cannot find a similar feature in Access

Liam

View 1 Replies View Related

Adding Time Values

Dec 29, 2006

I have a report that adds time for as many as six people. This isssue is when the time goes over 24 hours in total it drops the hours. The field(s) is formated in "short time" format.

Can anyone help resolve this???:confused:

View 6 Replies View Related

Adding One Hour Onto Time

Jun 14, 2007

Hi,
ive searched the forums for this but cant find anywhere.

how can i add one hour onto a time stamp please.

many thanks:confused:

View 4 Replies View Related

2 Users Adding Records At The Same Time?

Mar 1, 2006

Is it possible to have 2 or more users adding records into the same table at the same time? They would not be editing, only data entry.

I am wondering if this would cause a problem for the auto numbering for the ID field.

View 2 Replies View Related

Adding Records With An Incrementing Time

Jun 9, 2005

I wan to create a table with a date / time starting at a specific time and then added a number of records with each record being a minute later than the first.

The starting point could be hard coded or by user entry and the loop would run for a certain number of times .....

Any ideas on how to do it ..... poss a macro :confused:

View 3 Replies View Related

Adding Date And Time To Text

Jul 5, 2005

Hi
Apologies first if there is an easy answer to this post as I'm new to Access.

I have a notes box on a form that users update with the latest progress of work done. At the end of each progress I would like Access to automatically add the date, time and user's network id so that I can track who did what and when.

Is there an easy way to code this?

View 3 Replies View Related

Adding Minutes To Time Based On Selection

Apr 28, 2005

My table, TblTYPE, will contain two field.
TYPE
DURATION

There will only be 7 records in this table:
FUS, 30 minutes
POS, 30 minutes
PRE, 30 minutes
NOV, 90 minutes
FUL, 90 minutes
ANN, 90 minutes
NPB, 60 minutes

1st question: How do I enter only minutes in the table for field 2?

------

I want the following to happen.
The end-user enters the start time and the type. As soon as the type is entered, field three calculates an end-time based on the start time and the type. When the type is entered, the minutes listed in field two of the type table are added to the start time (giving you an end time).

Can anyone help me?
1.) How to properly format the minutes in the original table.
2.) How to add the minutes to the original time in a query.

Thanks!
Scott

View 2 Replies View Related

Adding Points To A Table On A Time Period

Aug 2, 2006

Can you help we have a data with a list of jobs that scores points, I need to build a query or scirpt that will add 5 points every 30 day fro the date the job was submitted this will help old jobs come the top of the list.

View 1 Replies View Related

Planning – Adding Time Management/registration

Dec 18, 2007

Hi all,

I’m adding a new function to our Costumer Relations Management system – Time management. Or maybe “time registration” is a better definition for it. The idea is that our consultants can add their hours into our CRM, either from the “Project”, “Tasks” or “Costumer” part of the CRM. Note: This is a tool to keep track of hours spent on a project, not a planning tool.

I’ve made the input-form for the records (Date, ClockStart, ClockStop, TimeSpent, InvoiceHours, etc.). But now I’m basically without a clue on where to start – I want to make a function almost like the calendar in Outlook, where the consultants can input what they’ve been working on, say between 13:00 and 14:00.

It doesn’t have to be fancy graphically, but functional and give a good overview.

Any ideas?

View 6 Replies View Related

Recall - Adding Times In Time Format

Feb 22, 2005

I want to calculate total hours and mins by adding a load of times (in time format) on a report. I've got the total number of minutes and converted this to hours : [txtmins]/60

Now I want to get the remaining minutes by using : [totalmins] - ([totalhours]*60)

However, how do I round DOWN the [totalhours] before it goes into the above sum. I can round it, but it always seems to round up.

If anyone has an easier solution let me know

Recall

View 1 Replies View Related

Adding Short Time In Query And Report

Apr 2, 2008

I am trying to add hours entered in a short time format. For example 08:15 or 02:55. I also would like it to give a total number of hours beyond 23:00. Here is a table with a Name Column and Hours Column

Name Hours
BETTER,HEATHER 8:00
BETTER,HEATHER 8:00
BETTER,HEATHER 5:41
BETTER,HEATHER 2:35
BETTER,HEATHER 1:15
WILLIAMS,R 2:30
WILLIAMS,R 0:45
WILLIAMS,R 11:20
WILLIAMS,R 8:25
WILLIAMS,R 8:15
WILLIAMS,R 10:20

How do I

A) write a query to add up the hours. I believe Heather would total 25:31 Hours.

B) Show this same total in a report? In my report I had a Name Footer which showed "=Sum([hours])". Will this work once the query is right or will I use the "=Sum([totaltime])"?

Also, is it possible for you to respond in a SQL statement so that I can copy? Thanks.

View 6 Replies View Related

Tables :: Adding Multiple IDs In A Table With Time

Mar 11, 2014

I want to make a table where in I have to input atleast 10 numbers in one reference ID which there is a start time and end time.

A form with inputing one reference ID and then adding multiple numbers at once and saving the data with a start time and end time. Is it possible to capture the time for that specific reference ID?

How to do it or a sample tracker on measuring it.

View 14 Replies View Related

Queries :: Adding Time Elapsed That Was Pre-calculated

Feb 24, 2014

Here is the table info I'm working with:

class status changeby changedate statustracking
INCIDENT-RESOLVED- Person A-2/20/2014 9:05 -
INCIDENT-RESOLVED-Person b-2/20/2014 11:57 -
INCIDENT-QUEUED-Person b-2/19/2014 13:57 - 01:24:08
INCIDENT-QUEUED-Person c-2/19/2014 15:21 - 19:29:58
INCIDENT-QUEUED-Person c-2/20/2014 10:51 - 01:06:00

I need to be able to add the statustracking time together per person per status (so person c would need 19:29:58 + 01:06:00 added together). Access keeps trying to add dates to the field or reconfigure the numbers to date ime or zeros if I use any of the data type other then Memo or text.

View 1 Replies View Related

General :: Adding TIME To Date Picker

Feb 10, 2014

I can make the DATE picker work, but I need to add the TIME to the same picker. At least that would be preferred.

View 6 Replies View Related

Export Adding Time Stamp To Date Field

Mar 6, 2006

I'm exporting a query from Access to an ASCII text file. It is automatically adding a time stamp (0:00:00) to the end of ALL of my date fields. I would like it if it didn't do this...:D

View 1 Replies View Related

Modules & VBA :: Adding Meeting To Outlook - Run Time Error 462

Feb 13, 2014

I have some code that creates appointment that i can send to colleagues, when I run the code first time it work all ok but the second time i run it i get a run time error see pic below

But I don't get any error's if i leave outlook open have also try the code on 2 pc's but stiil same problem

1392336756_tmp_run_time_error[1].jpg

Code:
Shell ("Outlook.exe")
Dim outMail As Object
Set outMail = Outlook.CreateItem(olAppointmentItem)
outMail.Recipients.Add (Me.txtsupervisor)

[Code] .....

View 3 Replies View Related

Modules & VBA :: Adding Data From List Box To Database One At A Time

Sep 12, 2013

how do you loop through and insert selected data from a listbox on at a time?For example, lets say you have an insert statement that has a firstname, lastname, CarsID(foreign key) and address field. Lets say you had another table that has ID and CarsID(primary key) field. In the listbox, you have populated it with all the cars and they are selected.

Example:

INSERT INTO PEOPLE(firstname, lastname, CarsID) VALUES('John','Smith','Honda')
INSERT INTO PEOPLE(firstname, lastname, CarsID) VALUES('John','Smith','FORD')

View 2 Replies View Related

Forms :: Adding Breaks On A Form - Start And End Time

Jun 18, 2014

I have an input form for production. I need to be able to have a unbound box look at the start time and end time. I need it to determine if the times fall during a break or lunch. My fields in my table are - ID, Start Time, End Time. Example of what I need the control source formula to do is this. If I start at 6:00 AM and work till 10:00.AM and my break is Start Time 9:00 AM... End Time 9:10 AM. I need it to then show 10 in the box as result of the break. I have this so far as in my formula builder.

IIF([Start Time]<9:00 AM AND [End Time]<9:10 AM, 10, 0)

When I press enter it says I have an syntax error and I have checked to make sure the fields are correct. Also how would I go about adding on to this formula to add a lunch break on to it.

View 10 Replies View Related

Modules & VBA :: Adding Time With Work Hours Function

Sep 13, 2014

In my DB that we use and a workflow tool, some of our work has and due date and time.If we get the complete_package our work time starts and we have X amount of time to complete our work. This is something i worked on but set it aside, now i am coming back to try and fine tune this so it returns a more accurate value.

So if we receive and [Date_Complete_Package_Received] at 09/13/2014 09:00:00 AM and based on the work being done we have 5 hours to complete the work, then the [Date_and_Time_Complete_Package_DUE] would be 09/13/2014 02:00:00 AM. That part is simple and i have coding that does that just fine. [SLA_Time] is where it gets the amount of time allotted, we have 5,10,12,14,and 16 hours depending on what is being done.

Code:
Me.Date_and_Time_Complete_Package_DUE = DateAdd("h", [SLA_Time], [Date_Complete_Package_Received])

This is done on AfterUpdate of a field on one of my forms and it works the way it is but what i need is to be able to run this through my Workhours Function so i am not getting values that our in off hours.The following doesn't work i know i can't use the Workhours function with the DateAdd but this is just to show what i am trying to do.

Code:
Me.Date_and_Time_Complete_Package_DUE = WorkHours(DateAdd("h", [SLA_Time], [Date_Complete_Package_Received]))

I have a Workhours module and it is used for a lot of things and it works perfectly.

View 1 Replies View Related

Reports :: Adding Page Numbers Adds Processing Time

May 15, 2013

I'm working on a pretty serious report (at least for me)...I have 3 sub-reports inside, and the point of this is to use VBA and loop through several conditions (in the underlying queries), and print out in a batch for the user. When I add a page number footer it adds about 3 seconds to the processing time for a 14 page report. That doesn't sound like a whole lot, but when I loop through and process this 12 times, that's a lot of added time for the user...(the last thing I want to hear is it's slow!)

So, would it be faster if I set the page numbers in VBA? What event would I use? On Load?!? Also, how would I find the page number variables in VBA?

View 1 Replies View Related

Forms :: Adding Duplicate Record To A Number Of Employees At Same Time

May 8, 2014

Currently if an employee attends a mandatory training session the details are entered individually into in a single table which contains all the employees' attendances to training, this is achieved via a bound form.

Works Fine.

My question is, if the training is carried out by a number of employees can this attendance be recorded on one form and assigned to each of the employees who attended?

Using Access 2003

View 3 Replies View Related

Forms :: Adding Three Fields In A Table - Time Difference Calculation

Oct 23, 2013

I want to add three fields in a table namely from, to and diff .

How to add them in a form so that I can enter

The time in (xx:xx) 24hr format in the "from" and "to" fields and calculate and save the time difference in minutes to the "diff" field automatically.

I am using access 2010.

View 8 Replies View Related

General :: Report That Show Daily Activities - Adding Time Lengths

Feb 25, 2014

I have a report that shows the daily activities. it shows how long it takes to do each task. however some tasks are 8 hours andsome are 10 hours. when all these times are added together it will give the time on a clock. not a total of hours spent.

i.e.
treatment1 : 8 hours
treatment2: 10 hours

this will give 06:00 in short time. in medium time it will give 18:00.

however if I add another 12 hours to that it will give 06:00.

I want it to show either 1 day and 4 hours /or 30 hours.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved