|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to Calculate hours between st. Date St.Time and End Date EndTiHi all,
In one of my form i need to show the total hours:Mins involved for a process by getting the user input as st. Date St.Time and End Date EndTime. I used 4 dtpicker for these and i tried with many conditions but i couldnt get it. I strongly believe that there should be some simple method to achieve this, Pls help me to come out of this problem. Thanks in advance... Prabhu. > In one of my form i need to show the total hours:Mins involved for a Give this procedure a try...> process by getting the user input as st. Date St.Time and End Date EndTime. I > used 4 dtpicker for these and i tried with many conditions but i couldnt get > it. I strongly believe that there should be some simple method to achieve > this, Pls help me to come out of this problem. StartDateTime = StartDate + StartTime EndDateTime = EndDate + EndTime DeltaTotal = DateDiff("n", StartDateTime, EndDateTime) / 1440 DeltaHours = Int(DeltaTotal) DeltaMinutes = DeltaTotal - DeltaHours DeltaHoursMinutes = CStr(DeltaHours) & ":" & _ Format$(60 * DeltaMinutes, "#") Rick - MVP 
Other interesting topics
Divide a path into a Drivename, Pathname, and Filename?
How should I select a folder, create and select the folder? Definition of an implementation SaveSetting question Return Security Events for Yesterday Emergency: Unicode Characters in a Dataset. Time fired event, error out of stack space How 2 get data from a web form DOS box and ALT_ENTER VB Package Deployment Problem |
|||||||||||||||||||||||
