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

how to enter only time in the field of table and sum the time

5
hi all can anybody help how write a query to get result if total hr exceed more than 24hrs.
I created a table having field name date,processdowntime as field name and
want to enter data in date field as date for 30days,10:20(hrs:min),12:10(hrs:min)
etc for 30days and finally on 30day i want sum and get the answer total hrs:min
thanks
Jul 24 '08 #1
2 2237
Dave44
153 100+
Just so i have this straight, for days 1 through 30 you will enter a certain number of hours and minutes, and then at the end of that 30 days you want to sum up all the hours and minutes?

If my assumption is correct you could just store the amount of time as a number of minutes for each day (eg. 10hrs:20mins = 620) and then just sum up the time on the 30th day and divide by 60 to get the number of hours and minutes in total.

you could also have 2 date fields for each day and store the start date/time and the end date/time, then just subtract the end date/time from the start date/time for each day and sum those up.
Jul 25 '08 #2
jvijay
5
thanks for reply.
Actually my question is
1)in which data type should i give for enter the time
in the table.eg:hr:min
2)suppose my table date processtime (hrs:min)
1/7/08 5:50
2/7/08 6:10
3/7/08 10:10
i want to sum processtime field only and show the result
in hrs:min.i.e total processtime 21:10(hrs:min).
how to write a query in oracle.
Jul 26 '08 #3

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

Similar topics

0
by: Galina | last post by:
Hello My form is based on a query returning rows of a table. Practically, it is based on a table, so simple the query is. A field on the form is formatted as short time. The column in the table,...
2
by: JC Mugs | last post by:
I have a form that when you tab from field to field that the entry point is blank, but if you point and click in the field it brings up a 0 and data entry is started to the left of the zero. ...
4
by: Won Mee | last post by:
I want to enter a value in a field and for that value that was entered to be multiplyed by 10 and then stored in a table. How do I do this? For example: =*10; Thanks, Won Mee
2
by: lgo | last post by:
I have read several variations of this topic posted on this news group. However I was not able to find the answer for my problem. I am trying to build code (see below) to update a large single...
8
by: doomx | last post by:
I'm using SQL scripts to create and alter tables in my DB I want to know if it's possible to fill the description(like in the Create table UI) using these scripts. EX: CREATE TABLE(...
2
by: buck | last post by:
I'm working on a helpdesk database - does anyone know how to auto enter the date in a new record; would it be soemthing like iif field is null auto enter?
3
by: Susan | last post by:
AccessXP When I use the wizard to create a form, all the textboxes are created with the Enter Key Behaviour of "New Line In Field". When I create the form manually the Enter Key Behaviour is...
1
by: aharding | last post by:
I have a form that displays data. I have a subform I created in the form, saved, deleted from form layout, and a command button that opens that subform. It works perfectly until I try to enter the...
24
by: MichaelK | last post by:
Who knows how to prevent submitting a form on the press Enter button before all fields on the form are filled up. People just enter the first field hit Enter and it submits the form and doing...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
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.