Converting time to seconds? [dd:hh:mm:ss}

Happy Tuesday......

(I searched, and didn’t find what I am looking for, so apologies if this has been addressed already)

I’m a data analyst – and I will always feel novice at excel haha.

Here’s my question, I’m exporting data of total Talk times per month, the data comes in the following format “dd:hh:mm:ss” I need to convert this to seconds. I know that =A1*24*60*60 normally works, and it does, only if the dd=00, example if the time is 00:08:24:35 it works, but if the time is 01:08:24:35 it does not work.. and I am stuck! Any assistance would be awesome!


Cheers!

Thanks for the quick reply (Can I attach a workbook?)

=isnumber() = FALSE on the date I am looking at - and the formet can be either "time" or "general" and I I get the same results.


It works if the there's no "day" but when its 1:20:43:17 [d:hh:mm:ss] I get the #VALUE! everytime! ugh.

It has to be the way the data is forematted - weird, the cells that the time is under 1 day, the cell is a number, however, the cells with 1:24:24:24 are static text. not actullay a number