You don't actually express time as days, hours, minutes and seconds the way
you have shown it. It is only hours, minutes and second

Assuming the time is in cell A1 *and* has zero days which can be ignored:

=RIGHT(A1,LEN(A1)-FIND(":",A1))*24*60*60 format as General

If you do have data in the format shown with days as the first element, you
could use:

=LEFT(A1,FIND(":",A1)-1)*24*60*60+RIGHT(A1,LEN(A1)-FIND(":",A1))*24*60*60

or

=(LEFT(A1,FIND(":",A1)-1)+RIGHT(A1,LEN(A1)-FIND(":",A1)))*24*60*60

Regards

Trevor


wrote in message
ups.com...
I would appreciate any help from an Excel guru out there that can help
me automatically convert a cell with a day:hours:minutes:seconds format
to seconds. So for example, 0:00:04:44 should be converted to 284.

Any ideas? Thanks in advance.