Convert Number To Hour

Jan 2, 2006

Hello Everybody...

I have a Question.
How do I convert a number (26) to 26:00 Hours.

The thing is.
I have a database that calculates the hours of overtime.

for example.

I work from 7:00 to 19:00.
Then I get 12:00 hours of total time.

The above is no problem.

But no I want to deduct the number 2 from 12:00 hours.

I hope to hear from u guys soon

View Replies


ADVERTISEMENT

Number Of Hour Worked

Jun 3, 2006

Hello!!!
I've a trouble:
I have an Access DataBase with two tables:
1--Workers with fields (ID, Name and $/hour)
2--Marks with fields(ID, WorkerID, Datetime of mark)

Well, I need to generate a report with the following structure:

Name Worker / Number of days worked / Total Cost in $
---------------------------------------------------------------------------
Worker 1 / 19 / 13000$
Worker 2 / 20 / 21354$
Worker 3 / 12 / 12000$
...

Example of Workers Table Data:
ID / Name / $/hour
-------------------------------------------------------------------------
21367 / Worker 1 / 21,34$
54883 / Worker 2 / 54,87$
87364 / Worker 3 / 5,38$

Example of Marks Table Data:
ID / IDWorker / DateTime-Mark
-------------------------------------------------------------------------
6754-54 / 21267 / 19/05/2006 8:05:32
4327-12 / 54883 / 19/05/2006 8:07:12
7645-98 / 87364 / 19/05/2006 8:13:54
5432-99 / 21267 / 19/05/2006 14:05:32
7584-23 / 54883 / 19/05/2006 14:07:12
9485-23 / 87364 / 19/05/2006 14:13:54
... / 21267 / 19/05/2006 16:05:32
... / 54883 / 19/05/2006 16:07:12
... / 87364 / 19/05/2006 16:13:54
... / 21267 / 19/05/2006 20:05:32
... / 54883 / 19/05/2006 20:07:12
... / 87364 / 19/05/2006 20:13:54
... / 21267 / 20/05/2006 8:05:32
... / 54883 / 20/05/2006 8:07:12
... / 87364 / 20/05/2006 8:13:54
... / 21267 / 20/05/2006 14:05:32
... / 54883 / 20/05/2006 14:07:12
... / 87364 / 20/05/2006 14:13:54
... / 21267 / 20/05/2006 16:05:32
... / 54883 / 20/05/2006 16:07:12
... / 87364 / 20/05/2006 16:13:54
... / 21267 / 20/05/2006 20:05:32
... / 54883 / 20/05/2006 20:07:12
... / 87364 / 20/05/2006 20:13:54

The condition to increment number of days is:
YEAR(date-mark) != YEAR(date-mark) OR
MONTH(date-mark) != MONTH(date-mark) OR
DAY(date-mark) != DAY(date-mark)

for example:
1)
19/05/1982...time-mark // Worker 1
19/05/1982...time-mark // Worker 1
19/05/1982...time-mark // Worker 1
19/05/1982...time-mark // Worker 1
-----------------------------------> 1 days worked
2)
20/05/1982...time-mark // Worker 1
20/05/1982...time-mark // Worker 1
21/05/1982...time-mark // Worker 1
21/05/1982...time-mark // Worker 1
-----------------------------------> 2 days worked

Do you understand it?

Well, I've tried several SQL sentences, but I can't make the definitive sentence. Can you help me, please?

Note --> each Mark-Datetime represents an instant of time!!!

View 1 Replies View Related

Query Maximum Number In Hour Per Day Every Cell ID

Jul 13, 2015

I need to know about "Need to query result from access2007 find only "one maximum number" in hour per day every cell ID"

How I use sql command?

See my file at ...

View 5 Replies View Related

Convert Positive Number To Negative Number

Nov 22, 2011

This has to be a simple way to convert a positive number to a negative number. For example, convert 5 to -5. The field is quanitity and I wanted to convert to negative number. I tried to use negative = "-" & [quantity] but it doesn't work.

View 2 Replies View Related

Convert Number

May 27, 2005

i have data stored in my paid field as negative ex: 000000460p which is $40.00. how can i convert this into $40.00?
I know i have to make a query but how can i make access pick up all the negatives that end in P and transform them into a negativ e number?
thanks

View 12 Replies View Related

Convert String To Number

May 31, 2005

I have a field on my Report called Revenue. It is used in a calculation and there is a calculated field called Profit. Revenue-Cost=Profit. That all works.

The only thing that is wrong is that the Revenue field displays its numbers like this:

0.7
12.43
4.3
0

etc.

i.e. not formatted for currency. But I don't get the currency option under Format. It is based on a Query and this Query is based on a Linked Table.

Any suggestions on how to get it formatted as currency while still having the calculated field working?

View 3 Replies View Related

Convert Date To Number

Aug 9, 2007

I would like to convert a date field to a number in a query. What I am trying to do is take 2 date fields and see how many days they are apart. For example if one date is 3/1/07 and the other is 3/1/06 I would like 365 days to be returned. Thanks for any help!

View 2 Replies View Related

Convert Number To Date

Aug 9, 2007

I am importing data from a text file that contains dates in this format: 08012007

I am trying to convert the number to a date 08/1/2007 so that I can run date related queries.

View 4 Replies View Related

Convert Text To Number

Aug 2, 2005

I have a table with the following fields:
Tool Text
Tool_ID Text
Description Text

The Tool_ID field holds a number if the tool provides a tool id. However, if the tool doesn't provide a tool id, the text "No tool ID given" is automatically placed into the field. Therefore, it needs to remain a text field for this reason and others that are too long to go into.
Anyway, I created a query that pulls only one specific tool which always provides a tool ID. Therefore, the results of my query will always have a number in the text field "Tool_ID".

Question: Is there a way to convert the text field to a number field within the query?

Thanks in advance!
~ Greg

View 4 Replies View Related

How To Convert Number To Date

Feb 28, 2008

I have a number, 20080101, that I need to convert to 01/01/2008.

How do I do this? I am not familiar enough with access to know.

Thanks.

View 6 Replies View Related

Convert Month Name To Number

Apr 9, 2008

Hi All - I would like the user to be able to import a month name (April for example) and then have access convert that name to a number (4) so that I can search for records that were opened before the month entered. I have been using:

MonthName(Month([CompletionDate])) = [Enter Month]

but

MonthName(Month([CompletionDate])) <= [Enter Month]

does not work.

Thanks!

View 1 Replies View Related

Convert Number To Month Name

Feb 4, 2008

Hi
I am struggling to get a number to change to a month name.
When the user chooses a month from a drop-down:

Value List
1;"January";2;"February";3;"March";4;"April";5;"May";6;"June";7;"July";8;"August";9;"September";10;"October";11;"November";12;"December"

I use the month number to run the query, ie: 1, 2, 3 etc.,
But I want the Month Name to use in the subsequent report.

I have no other data in the query other than a month number to use so I thought about an invisible text box that get's the month number and I could reference it from the report, but I just can't get the text box to get the month name from the drop-down.

=Month([Month4Query].[Column](2))

Maybe there is a better, easier way?

Martin

View 3 Replies View Related

Forms :: VBA - Whole Number Convert To Hh:mm

Aug 14, 2013

I have a textbox that I put in minutes as whole number. What i want is to put in AfterUpdate Event to convert that whole number to hh:mm....

View 4 Replies View Related

Currency Convert From Digits To Number

Nov 7, 2007

dear frnd,

i have a access program for printing cheque. i want to use a text box which automaticaly convert number ito digits from user input text box.

View 1 Replies View Related

How Can I Convert A Week Number To A Month?

Sep 29, 2005

Help!!
I have 2 fields in a table one for a year and one for a week number that data is being collected against.
I need to change these to a month and year for the report. Is there a way to do this??

View 1 Replies View Related

Convert Number To Text In Query

Dec 1, 2007

I want to have a question in my query that does not get answered by date but by a concatenated field named "MonthYearPeriod".

We always forget how many days in a month. But we remember the month and year. So for say a Sales Range of Nov 2006 to Oct 2007, we prefer to respond to the criteria question as: 11-2006 and then 10-2007.

FiscalMonth and FiscalYear are both Long Integer number fields in the table.

Query field concatenated:
MonthYearPeriod: [FiscalMonth] & "-" & [FiscalYear]

criteria line:
Between [Month-Year START DATE] And [Month-Year END DATE]

However, i get other crazy time periods. So this is not working. Maybe on the Query field box, I need extra coding to convert the number to text?

I assume that a Dash sign between the month and year are fine.
Thanks

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

Queries :: Convert Number To Date?

Nov 11, 2013

i need to convert a number string to a date For example, 0820 i would need to convert it to august 2020 ( the date will always be in this century)

View 3 Replies View Related

Queries :: Convert String To Number

Dec 17, 2013

how I can convert the first column to show the number? I used the expression below, but it does not convert anything with a letter or a 0

Expr1: Val([SPPC TEST]![JULY_ACCRUAL_ADJ_X])

View 7 Replies View Related

Queries :: Convert Date To Number

Jun 18, 2015

Trying to convert a date in my query to a number. What function will convert 6/17/2015 to 42172? Tried datevalue dateserial

View 3 Replies View Related

General :: How To Convert A Number To Time

May 23, 2014

I would like to convert a number such as 15.25 to 3:15 pm. What is the easiest way to accomplish this?

View 2 Replies View Related

How To Convert A String To Number Or Vice Vese?

Sep 14, 2005

Hi!

I have two tables Atable and BTable and both have a field called AcctNo. In Atable, it is type of Number and in BTable, it is type of Text. When I do a join with these two tables

select * from Atable, BTable where Atable.AcctNo=Btable.AcctNo

I get error saying "type mismatch".

My question here is: How can I convert a type from number to string or string to number in my sql statement?


Thanks,

Aijun.

View 3 Replies View Related

Convert Short Time To A Number (seconds)

Feb 26, 2006

This must have been answered before, but I can't find it by searching so sorry for the dumb question.

I input a time in hours and minutes in a field with a Short Time format. I would like then to convert this to seconds in a field with a number format so that I can total the seconds and then add them to the results of a calculated DateDiff control to get the grand total of time spent on a project.

Any help would be gratefully received.

Cheers

Rob

View 2 Replies View Related

General :: Convert Number To Short Time

Feb 12, 2014

How can I convert a number format into a short time format?

View 3 Replies View Related

Queries :: Convert Date To General Number?

Mar 20, 2015

Is it possible to easily convert 02/02/2015 15:30:00 to 201502021530 in a query?

View 4 Replies View Related

Forms :: Convert Currency (Or Number) Into Words

Feb 19, 2015

Is it possible to convert a number (whether in the "Standard" or "Currency" format) into words ?

View 5 Replies View Related







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