Time Exceeding 23 Hours 59 Minutes

Nov 2, 2004

Hi,
I have a bit of a problem. I am making a program in access 2002. In my program you should punch in hours:minutes, this is for keeping track of how long a job has taken to perform. The problem is that it could exceed 23:59, it could take up to a week or even more. In my database we have already put in a lot of info where it doesn't exceed the 23:59, I would like to keep this posts and just to put in new ones that I could use further on when I am about to take out reports, where I have to calculate time. Is there someone who knows what to do ??

Regards

Greger

View Replies


ADVERTISEMENT

Total Time On Hours And Minutes

Jan 29, 2007

Hi,
I am trying to show the time difference between 2 times but the calculation is not working correctly.

First I work out the totaltime on mins between 2 dates using datediff, then I am trying to convert to hours and minutes like :
Total_Time: Format([Sumoftotaltime_mins]/60,"00") & ":" & Format([SumofTotaltime_mins] Mod 60,"00")

This is working until I have something like :

03:00
15:45
25:20

this should work out as 44 hours and 5 mins but for some reason it is showing as 43 hours and 5 mins.

why would this be ?

View 4 Replies View Related

Converting Minutes From A Query To Hours:Minutes On A Report

Jun 12, 2013

Basically I have a table setup where Time Fields are stored. What I need to do is in a Query, have the difference of two Time Fields calculated, and then displayed on a Report. Here's what I have so far...

Table

- Start Time
- End Time

Query

Difference Time: DateDiff("n",[Start Time],[End Time])

All that works fine and shows up on the report, except for the fact that the time is showed in straight minutes, so for a difference of 1:30 minutes, it just shows 90 minutes. I need to make it so that on the report in the Difference Time Text Box, it's showed as 1:30 instead of 90.

I tried putting the following in the Control Source for the Difference Time Text Box on the report, but it returns an error.

=[Difference Time] 60 & Format([Difference Time] Mod 60, ":00")

View 4 Replies View Related

Convert Hours & Minutes To Minutes

Jan 22, 2008

How can I convert hours and minutes to minutes as an Integer?

For example, convert 2:15 to 135.

Any help is greatly appreciated.

View 8 Replies View Related

Datediff Minutes And Hours

Feb 3, 2006

I would like to calculate the time difference between two dates, what ive got so far is

TimeSpent: DateDiff("n",[datein],[dateout])

This calculates the minutes between two dates, Can you format this so that it calculates hours. minutes for example 124 minutes would be 2.04?

I thought using "h/n" might work but it hasnt
thanks

View 1 Replies View Related

Hours Minutes Format And Calculation

Oct 31, 2007

Hello everyone,
I am new to this forum, this is my first time. I hope someone can help me with my problem. I am creating a small database using Access at my work place. I came forward with 2 problems.
1. I need to create a field (Down Time) in a form that can store hours and minutes like 40:30. If I format the field as Short Date it wont allow me value higher than 23:59. Also, let you know that I am using the field (Down Time) in a calculation.i.e. Run Time - Down Time = Actual Time.
2.I also need a help on for the following calculation.
Unit per Minute =Quantity(number field)/Actual Time.
Your help is greatly appriciated.

View 2 Replies View Related

Total Hours (or Minutes) In A Query

Oct 9, 2007

I have a table wherein the time worked by 25 employees are recorded. This table has the start time, endtime, break time and late times. The Late Time is the number of minutes that the employee is late to work. I am required to do a query of the team's (all 25 staff) late times per month. I have done a query which shows the late times of the individual on the dates that they were late to work and created a crosstab query for that.

I am going around in circles. How can I have a total of the team's late times in a query? Please, could someone please point me in the right direction?

View 6 Replies View Related

Forms :: Hours Can Only Increment By 15 Minutes

Feb 2, 2015

For Example: I have a field, let's say called Hours set to Data Type Number and Double format.

The user should only be able to enter time in 1/4 hr increments.

1 hr or 1.25 or 1.5 etc...

View 8 Replies View Related

Reports :: Converting Minutes To Hours

Jan 12, 2015

I have a query that uses DateDiff to give me Minutes of an in and out time.Online I found the following to use in a textbox control source on a report to convert the minutes to Hours:Minutes.

=[Minutes] 60 & Format([Minutes] Mod 60, ":00")

But when I enter this it gives me an error. I am not sure how to fix it. I tried writing it like this with RegHours being the source of that column

=[RegHours]60& Format([RegHours] mod 60, ":00")

but when I go back to report view that text box then says #Type!

View 1 Replies View Related

Converting Minutes Into Hours In Report

Apr 1, 2013

I have a tracking database I have been working on and so close of being done just held up on this last part. What I am trying to do is have the totals = Ex. 1.25 + 3.50 would give Grand total of 5.15 not 4.75. The table has a field called time spent which stores the time. I have attached an example database. So whenever the minutes = more then 60 for it to add 1 to the hour.

View 13 Replies View Related

Reports :: Sum Of Calculated Field In Hours / Minutes Format?

Sep 1, 2013

I have a table of timecards each recording minutes spent on each task for each client and I have summed those minutes by client in a query.I have then in the same query converted each sum of minutes to hrs:mins format using this calculated field:

HrsMins: [SumOfMinTime]60 & Format([SumOfMinTime] Mod 60,":00")

So this turns e.g. 261 minutes into 4:21..Based on that query I have a report showing total hrs:mins spent on each client, e.g.

Smith 4:21
Jones 5:32
James 1:23

Now I want to show a total at the bottom, i.e. in the above example it would be 11:16.So for the control source for a total field on the report I tried:

=Sum([HrsMins])

But when I do that I get an error message: "Data type mismatch in critieria expression"I may be because I am trying to sum calculated fields amounts that are calculated using a function.Or it may be that the format is not being recognised as hours and minutes and thus cannot be added up.way in which I could get a total here in hours and minutes format (hrs:mins).

View 5 Replies View Related

Calender ActiveX Control Display Also Hours, Minutes And Seconds

Jul 22, 2007

I am using the calender control 11.0. By this calender I can only set the date year, month and day. I can not set the clock time:Hours, minutes and seconds. Is there a calender that enables me to set the date in the format:dd-mm-yyyy HH:MM:SS, means day,month,year Hour:Minutes:Seconds.


Grateful

View 1 Replies View Related

Queries :: Utilization Database - Calculating Hours Minutes From Decimal

Apr 23, 2015

I'm working on a utilization database and pulling Excel data from Cognos 8. I use Access formulas to separate hours and minutes because I want to use time (.30, .45 (minutes)) instead of quarterly increments (.25, .50). I've successfully segregated hours, because I also have to turn days into hours. When I try to calculate out a column just for minutes, my formula keeps the number of days and I don't know how to fix it so the column just shows the minutes.

An example is a job has a decimal time of 2.02083333, which when done correctly is 48 hours and 30 minutes. I get the 48 hours correct, but the minutes shows as 2.30 instead of 0.30. That inflates the total job time to 50.30. This is the calculation currently in my database to pull out minutes:

Minutes: Int(([Min]60)24) & "." & Format([Min] Mod 60,"00").

How do I get rid of the '2' in the 2.30?

Access 2010

View 2 Replies View Related

2 Minutes Of Your Time Please

Mar 1, 2007

Hello all,

This forum has been a lifesaver in the past and I hope someone can help me now.

I have a Contacts form that is used to input all the client's information. (name, date of birth, address etc).

I want to be able to force the person entering the data to not be allowed to tab to the 2nd text box (or any other text box on the page) unless in the first text box data has been entered (the first text box is client name)

However, I also need to be able to overide this if the person entering the data clicks on a "Cancel" button (another button on the page which closes the form).

Is this possible and if it is any help would be greatly appreciated!

Thank you in advance,

Rob

View 14 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

Convert Time Into Minutes Value

Mar 31, 2008

Hope some one can help I have a field with a time value in it in the format:

08:30 (this is a date/time field) what I would like to do is convert this value in a query to minutes.

Ie.

08:30 (8 hours 30 minutes) convertes to 510 minutes. any pointers. Thanks.

View 1 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

Convert Minutes From Number To Time

Mar 30, 2006

Is there any way to take a field that is a whole number and convert that number to appear like a time?

i.e.

120 shows as 2:00
106 shows as 1:46
25 shows as 0:25

View 2 Replies View Related

General :: Database Time Out (More Than 30 Minutes)

Jun 27, 2012

Is there a way to make a shared (split) database automatically log/time users out if they leave it open/idle for too long (ie: more than 30 minutes)?

View 1 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

Reports :: Average Of Time In Minutes And Seconds

Feb 7, 2014

Basically, I get daily reports from the client and the AHT and ACW values come in seconds. I've recently added code to the query changing the data to nn:ss which works perfectly. Below is some info:

tblTelephony
[AgentName]
[Calls] (number of calls answered)
[AHT] (in seconds)
[ACW] (in seconds)

[Code] ....

The above code works very well, where I'm stuck is in the attempt to average the fields [AHTMinSec] & [ACWMinSec] by Agent in a report.

Using [AHTMinSec] as an example:

I have the daily values for each agent [AHTMinSec] in the detail, Avg([AHTMinSec]) in the Agent group footer showing each agent's average, Avg([AHTMinSec]) in the Team group footer showing team averages and Avg([AHTMinSec]) in the report footer showing the campaign average including all teams. When I run the report the details are hidden providing each agent's average, the team average, and the campaign average.

The report worked just fine until I converted to minutes with the above code. Is there a reason that I'm getting an error stating that the calculation is too complex? I've done enough research to determine that the db can't Sum in order to average...

View 12 Replies View Related

Modules & VBA :: How To Modify Code To Accommodate Time That Exceed 1440 Minutes

Oct 8, 2014

I have a function that formats minutes to "hh:mm:ss" but its doesnt work if minutes is equal to or greater than 1440 minutes/24 hrs.

Code:
Forms![frmTasksTimer]!estimate_time = FormatTime(Forms![frmTasksTimer]!amount_left, Forms![frmTasksTimer]!Rate)

Code:
Function FormatTime(Amount As Double, Rate As Double) As String
Dim x As String
x = CStr(Round(Amount / Rate * 60))
FormatTime = Format(x / 1440, "hh:mm:ss")
End Function

How can i modify this code to accommodate time that exceed 1440 minutes?

View 9 Replies View Related

Time In Excess Of 24 Hours

Apr 10, 2006

Looking to have a time field that a user can enter how long they worked an issue. Format should be ##:##, but I'm afraid that if I use text, calculations will be impossible.
How does someone do this if it's expected that the value will frequently go over 24 hours?

View 5 Replies View Related

Subtracting Time Over 24 Hours?

Mar 27, 2006

Any Help!

I have fields that are time formated 99/99/99" "00:00;0;_ and I want to subtract them.

I need to get the results in two forms; first in Days and second in Hours. I have used the obvious subtract one from the other and it gives me days in a rounded numbeer, but the hours is not working out.:confused:

DB

View 4 Replies View Related

Hours Time Problem

Jun 27, 2006

I want to create a query that will calculate the following:

When a user enters a start time and an end time in 2 seperate fields (eg. 06:00 and 08:00) I want to automatically return how many hours fall between 00:00 to 01:00, 01:00 to 02:00, 02:00 to 03:00 etc through the 24 hour clock.

To give you a background why I want this, I'm creating a labour planning database that calculates the nuber of people available each hour in a warehouse. So when a user inputs 06:00 to 08:00 for overtime work I need the database to tell me 1 hour falls between 06:00 to 07:00 and 1 hour between 07:00 to 08:00.

I'm really struggling to come up with a solution to this one, any help would be appreciated.

View 1 Replies View Related

Need Help With Time/ Hours Worked Calculation

Jan 22, 2006

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 4 Replies View Related







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