473,322 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Time calculation problems

I am trying to get a result that will show me the difference, in hours and
minutes, between two times. The application is on a staffing roster, and
what i want to be able to do is calculate working hours in the day, so
difference between start time and finish time less a predetermined amount
for lunch breaks (1/2 hour). So if someone starts at 9am and finishes at
5pm, i need the result to be 7 1/2 hours.

I have been unable to find a solution to this, so any help would be greatly
appreciated

glenn
Nov 12 '05 #1
1 4416
Create a query into this table.

Type a calculated field into the Field row of query design:
Hours: (DateDiff("n", [StartTime], [FinishTime]) - 30) / 60

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Glenn Cornish" <gl***@southwest.com.au> wrote in message
news:3f********@usenet.per.paradox.net.au...
I am trying to get a result that will show me the difference, in hours and
minutes, between two times. The application is on a staffing roster, and
what i want to be able to do is calculate working hours in the day, so
difference between start time and finish time less a predetermined amount
for lunch breaks (1/2 hour). So if someone starts at 9am and finishes at
5pm, i need the result to be 7 1/2 hours.

I have been unable to find a solution to this, so any help would be greatly appreciated

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

96
by: John Harrison | last post by:
I knew that unsigned integral data types were the cause of scads of mostly spurious warning messages, but I didn't realise that they were a security risk too (see here...
5
by: Tom | last post by:
A field in a data set I want to import into Access is in Unix time (seconds from a certain time on a certain date). Does anyone know the precise date and the precise time on that date that Unix is...
0
by: Limpor | last post by:
Hello, I am new to learning java, and i am trying to build the class for a calculation card game, unfortunately i can't get the public Card top() and Card takeTop() method in the Stock class. Can...
33
by: ram.ragu | last post by:
hi i have problem to calculate idle time of cpu and if idle time is more then i have to shut down the system. can anyone tell me the idea to so that please
8
by: andreas | last post by:
Hi, I have a calculation program in vb.net who is running for let us say for more than a hour. When I will do meanwhile something els in a office program I see that my calculation program takes a...
6
by: faizal87 | last post by:
i've some problems in creating a program using V.B since i'm new in learning this language. basically i learn V.B just by browsing the net by myself without any guide from other people. i need to...
1
by: Michiel van der Blonk | last post by:
It's probably something with rounding off, or floating point problems. I have a timer which is used when solving the Rubik's cube. It has to measure an exact time, but the clock display I made...
1
by: juliacjy | last post by:
Dear all, I'm needing an urgent help. I'm now maintaining a system which has a function of "Automatic Calculation". User is allowed to set of a time which then will be stored in one of my sql...
1
by: faizah | last post by:
hai,i'm a beginner in php, i have some problems dealing with calculation. can we make complex calculation using php involving add,minus, and other mathematical operations?and the other thing, how I...
6
by: Lara1 | last post by:
I'm trying to get certain cells to show a hovering alert message when I click on them. (I don't want an error-message style box to pop up, because I'll eventually want it to show for lots of cells...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.