different between two time

surendran · April 18th, 2007, 11:11 PM

Hi... i need an idea on how to do this...
let say i have to time....

8:55:35 and 10:30:35

what is the algorithm to calculate between this to time. I need to know the number of time in same format(hh:mm:ss)...

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

gbianchi · April 19th, 2007, 07:16 AM

hi there...

datediff will tell you the diference between 2 dates, but only in 1 format (for example only the diference in seconds...)

but after that you can compute the everything with this algorithm:
result /3600 = hours (always use integer number)
result - (hours*3600) = seconds left
newresult / 60 = minutes
newresult - (minutes*60) = seconds left

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

BrianWren · April 19th, 2007, 10:03 AM

I don't know if the folowing will help you in your particular case, but it might.

I am taking two times as strings, converting them to dates, subtracting one from the other, and converting the result to a date. (Date type is the general type for all time-formatted items.)
The stuff I am showing is out of VB6âs Immediate Window (coloring for clarity, note the AM/PM value of the result):

Code:

?CDate( CDate("10:45:12 AM")  -  CDate("8:12:12 AM") )
2:33:00 [u]A</u>M 

?CDate( CDate("10:45:12 PM")  -  CDate("8:12:12 AM") )
2:33:00 [u]P</u>M

gbianchi · April 19th, 2007, 10:24 AM

uh.. nice solution!

use brians solution surendran...

just add 12 hours when you get PM...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========