Time Conversion
Posted by Bob Brooks on August 30, 2000 9:41 AM
I am trying to devise a formula for converting hours:minutes:seconds into seconds in order to calculate an accurate machine process time.
An example is (Cell A1)(Cell B1) (Cell C1) (Cell D1)
04:15:00 04:19:25 = 00:04:25 (265)
Using the formula: =sum(b1-a1) (???)
I need (Cell D1) to take the value in C1 and convert to total Seconds (265). Any suggestions will be appreciated.