"lkeeton" <[EMAIL PROTECTED]> wrote: > from here is where i need a solution that gets me the difference of these two > times in a decimal format. Of course once I get that I may need to convert > back in english to say there are 30 minutes and 44 seconds. You didn't state whether you're using a web scripting language, but if you're using PHP I have a PHP function which I wrote that you could easily edit to do what you're attempting. http://www.befriend.com/code_gallery/php/get_elapsed_time/ -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php