convert dd:hh:mm:ss to seconds
I need to change some data to seconds. One of the problems is that some of
the data in the column is a subtotal, so the data is dd:hh:mm:ss where some
of it is hh:mm:ss.
Is there one formula that I can use as part of others (IF, SUMPRODUCT, etc.)
that coverts both dd:hh:mm:ss and hh:mm:ss to seconds?
I currently just multiply hh:mm:ss by 86400 to convert it to seconds.
TIA,
Greg
|