473,324 Members | 2,356 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,324 software developers and data experts.

sum of times off by 2 minutes

I've got three columns i'm working on: Time Start (Date and Time), Time
End (Date and Time), Total Task Time (Short Time)

I've got Total Task Time working correctly. Here is my query:
SELECT Format(Sum([Total Task Time]),"hh:mm:ss")
FROM Task_LogTest;

However, I manually added it up (I've got 4 test rows) and the query is
returning a time that is off by 2 minutes exactly (my result + 2 min).
Any ideas on why this is happening?

Dec 15 '06 #1
0 1035

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

Similar topics

0
by: SimonC | last post by:
I'm looking to do something similar to a feature found on Ticketmaster.com, where you select your seats at a venue, and then you have two minutes in which to take or leave them. QUESTION 1a....
3
by: James P. | last post by:
Hello there, I'd like to have my minutes convert to hours and minutes in Access report in this format: hh:mm. For examples: 150 minutes converts to 2:30. I have this formula below used to work...
14
by: Steve McLellan | last post by:
Hi, Sorry to repost, but this is becoming aggravating, and causing me a lot of wasted time. I've got a reasonably large mixed C++ project, and after a number of builds (but not a constant...
3
by: Andy Green | last post by:
Hello! I've got a problem with an ASP.NET app... The app is running in conjunction with the Session State server, and they both run on the same machine. I've changed the default timeouts in...
8
by: Amith Singh | last post by:
When the sessions times out I would like to take the user to the login page. Currently even though session times out user will come to know only when he clicks on the screen. How to direct the user...
6
by: James Goodman | last post by:
I have modified the ASP.NET TimeTracker Starter Kit to include the ability for users to log working hours (Start Time, Finish Time, Lunch Duration). This is then presented to them in a grid & a...
87
by: John Rivers | last post by:
Hello everybody, I just wondered if anybody else has noticed this? It takes around 6 seconds to start debugging a very simple ASPX page with VS.NET whereas VB6 takes under 0.5 seconds, even...
3
by: Drew | last post by:
I've got three columns i'm working on: Time Start (Date and Time), Time End (Date and Time), Total Task Time (Short Time) I've got Total Task Time working correctly. Here is my query: SELECT...
1
by: Nigel Heald | last post by:
Hi Folks, We have a form that records flight times in hours and minutes, for example a 1 hour 15 minute flight is recorded as 1:15 Does anyone know how to get Access 2003 to calculate a total...
3
by: Brian | last post by:
I need to be able to only allow my clients to enter data into a part of a form between specific hours of the day. i can find tons of articles on comparing dates, but not times. does anyone know...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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.