473,323 Members | 1,560 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,323 software developers and data experts.

how to sum time in ms access

5
hi all
i have created a table runtime and entered values as
10:20
5:20
15:30
sum of this time is 30:10
how to write a query so that i can get 30:10 as my answer
thanks
vijay
Jul 22 '08 #1
4 4236
missinglinq
3,532 Expert 2GB
First off, assuming this is supposed to be either minutes and seconds or hours and minutes,

10:20 + 5:20 + 15:30

is going to be

31:10


not

30:10.

I assume this is being stored in a text field, is this correct?

Where are these "times" coming from?

Welcome to Bytes!

Linq ;0)>
Jul 22 '08 #2
jvijay
5
I have create a table in which i created a field as runtime date/time data type and in general formart i selected shorttime then saved the table then i entered the values as 10:20 , 5:20 , 15:30 as hours :minitues .i want to sum this runtime get the answer as 31:10 (hours:mintues).how to get the result as 31:10
thanks.
Jul 23 '08 #3
Stewart Ross
2,545 Expert Mod 2GB
jvijay please do not double-post your questions, which is against site rules and wastes the time of the volunteer contributors to this forum. I have deleted the other thread, a duplicate of post 3 in a separate post.

Linq has asked you for clarification of a point, yet in post 3 you have merely repeated the same data except for correction of your total - this is not answering his request. To post a new thread when you have not answered the question asked in this thread is discourteous. Please be advised that we will not allow misuse of the forum in this way.

Please read our posting guidelines, which are there to help you get the best from this forum.

MODERATOR
Jul 23 '08 #4
jvijay
5
jvijay please do not double-post your questions, which is against site rules and wastes the time of the volunteer contributors to this forum. I have deleted the other thread, a duplicate of post 3 in a separate post.

Linq has asked you for clarification of a point, yet in post 3 you have merely repeated the same data except for correction of your total - this is not answering his request. To post a new thread when you have not answered the question asked in this thread is discourteous. Please be advised that we will not allow misuse of the forum in this way.

Please read our posting guidelines, which are there to help you get the best from this forum.

MODERATOR

I am sorry i could not understand how to thread my reply so i post new question
correcting my question
actually my question is
I have create a table in which i created a field as runtime date/time data type and in general formart i selected shorttime then saved the table. I entered the values as 10:20 , 5:20 , 15:30 as hours :minitues .I want to sum this runtime get the answer as 31:10 (hours:mintues).How to get the result as 31:10(hrs:min) in ms access.
thanks.
jvijay
Jul 24 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: rbt | last post by:
I'm using the standard NTFS file system. The only time the access time is updated is when the file is modified or saved (with no changes). What's up with that? Shouldn't a read/view update the...
4
by: Mark Reed | last post by:
Hi all, I have a query (query1) which shows scan date, scan time & operator. One scan = 1 record. What I want to do is create a report based on query 2 from query1 which shows all the scans AND...
7
by: Morley | last post by:
1. Is the run time version a self-contained file which includes Access files and a database or are there separate Access files and a database (.mdb) file? 2. If the database file is separate,...
2
by: Steve Miller | last post by:
hello... i am a 'user' of access, meaning, i import excel files, join, and merge....that's about the extent of my expertise with ms-access. my boss wants me to create an access application that...
3
by: luscus | last post by:
Thanks for all the responses on my first question. Unfortunately the answers I was given were too complicated for my small brain , and neophite condition to understand. So if you could talk down to...
9
by: Bob Achgill | last post by:
I would like to use the timestamp on files to manage the currency of support files for my VB windows application. In this case I would only put the timestamp of the file in the management database...
5
by: Takeadoe | last post by:
Gang - I'm generating date and time variables from scanned forms. Currently, the date and time values are as follows: 06/26/2006 and 11:30 AM. I've written VBA code to combine them into a...
3
by: Jim in Arizona | last post by:
I have a gridview that's being populated from an access db query. The problem I'm having is that the date/time fields in access that are populating the gridview are showing both date and time, when...
9
by: pob | last post by:
I currently have a procedure that loops thru a recordset to determine what files need to be loaded to my database. The naming convention of the files has always been accounts.txt, namelist.txt,...
3
by: Paul H | last post by:
Most of my projects are developed in Access 2003. I have not even installed Office 2007 yet! I need to buy VSTO to get the run-time licence for Access 2003. No doubt I will soon need a run-time...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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
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...

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.