•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 427,227 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,216 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 683 | Replies: 4
 |
•
•
Join Date: Oct 2005
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I have a time values in MS Access database
4:30
2:15
3:20
4:45
I want to sum the time using VB code .The sum of the time should be 14:50 hrs not 14:10 hrs. Please help
4:30
2:15
3:20
4:45
I want to sum the time using VB code .The sum of the time should be 14:50 hrs not 14:10 hrs. Please help
•
•
Join Date: Feb 2008
Location: Sivakasi, Tamilnadu, India
Posts: 459
Reputation:
Rep Power: 1
Solved Threads: 79
Posting Pro in Training
Hi, i think adding two time values are possible in VB6 just using time1 + time2.
Ex
Ex
VB Syntax (Toggle Plain Text)
Last edited by selvaganapathy : Jul 11th, 2008 at 9:46 am.
KSG
•
•
Join Date: Nov 2006
Posts: 712
Reputation:
Rep Power: 3
Solved Threads: 97
Master Poster
Hi,
You want to get Total in a Single Query..?
Is the Field in Access Table DateTime field or Single/Decimal field..?
You can do it in a single query...
Regards
Veena
You want to get Total in a Single Query..?
Is the Field in Access Table DateTime field or Single/Decimal field..?
You can do it in a single query...
Regards
Veena
•
•
Join Date: Oct 2005
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by QVeen72 
Hi,
You want to get Total in a Single Query..?
Is the Field in Access Table DateTime field or Single/Decimal field..?
You can do it in a single query...
Regards
Veena
It is MS Access Date/time field. I tried using sum function but I did not get correct result.
•
•
Join Date: Nov 2006
Posts: 712
Reputation:
Rep Power: 3
Solved Threads: 97
Master Poster
Hi,
Instead of simply using Sum, use this Query:
Select Sum(Val(MyDateTimeFld)) From MyTable
You will get total Time,
Later you need to get the Decimal Part, Integer Divide by 60, add it to Hours part, and keep the remainder in Decimal for Minutes..
Regards
Veena
Instead of simply using Sum, use this Query:
Select Sum(Val(MyDateTimeFld)) From MyTable
You will get total Time,
Later you need to get the Decimal Part, Integer Divide by 60, add it to Hours part, and keep the remainder in Decimal for Minutes..
Regards
Veena
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Intermittent internet connection is driving me nuts (Networking Hardware Configuration)
- adding date or time to beginning of filename (PHP)
- Can anyone help me with adding 2 polynomials together? (C++)
- Need help with adding a page hit counter that uses the Application Bean (JSP)
- How can i add textbox values to listbox values.... (PHP)
- Adding Records to combo and searching them (Visual Basic 4 / 5 / 6)
- retrieve time from database (C#)
- Adding minutes to a timestamp (PHP)
- Adding mouse listener to a frame (Java)
- Another HotOffers Hijack (HJT log incl) (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: list box problem
- Next Thread: Whats Tabel Using ???
