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

total of time work grater than 24

hi
i need to give sum of total time in a query or form or report
i have a table that in table time of work a feww machin saved
for example at the end of each mount i nee to give sum of timw worked
when in query i use sum when i run the query it showed wrong
for any number less than 24 it worked normal and showed correct but for grater than 24 it not be show correct
i think that may be i must be use a special format for sum
please help me if is possible
Nov 7 '13 #1
0 877

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

Similar topics

2
by: MLH | last post by:
I have tblMemberLogins with and fields. Any member may appear in the table numerous times. How can I sum up the total time spent logged in by any member in the table, I can extract the records...
2
by: Supra | last post by:
i know how to get filesize (using filelen) but don't how to get total time. i am using mpegs or songs. i can retreived filename but not total times in listhbox. i done in vb6 b4. 300 = 30 sec...
17
by: barkarlo | last post by:
I need help to make grand total time in continuous forms. to calculate total work time I use following formula =format(+1--nz();"short time"). but when I make grand total time in form footer (for...
2
by: Guizones | last post by:
Hello, I have one table that has a column called CallDuration. This columns has always the format "1/01/2000 12:01:38 AM". The date part "1/01/2000" I want to discard, and sum the time part to get...
2
by: vssp | last post by:
hai friends I have uploaded the video file to server .we need to get the total time of playing file duration and store the values to database. how can i get the total time for uploaded video file? ...
14
meLady
by: meLady | last post by:
Hello, Here I am having a little bit confusion about how to calculate the total time of steps of a process (for example: registering a new user for a website) in MS Access: - step1: entering a...
1
by: reshmaarora22 | last post by:
hi i have i table called Description which has details about StartTime , EndTime and ScheduleDate of the various Transaction occuring daily.I want to fetch total time spend on a particular...
3
by: John Torres | last post by:
how do you calculate total time hours? I have sub total hours for each day and I've been trying to total all the hours. I'm getting odd numbers. Thanks. John
0
by: progvar | last post by:
Hi I used the formula in xls sheet like = 985 / (2:26:25 *24) * 7.5 and i got answer = 7:38:47 and then i changed the format of cell into number and final answer is 3027 where 7.5 is total time...
1
by: visweswaran28 | last post by:
I created one crystal report in that i print time for each user. finally i want to calculate total time. so wat should i do to calculate total time. i tried with sum method......
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.