need help finding total seconds

**olive** · 04-29-2010, 01:09 AM

Hi Guys,

Am hoping that someone can help. If I have a cell in excel that has 08:29:52 being hh:mm:ss and I need to know the total in seconds, how would i do that?

Thanks

olive

**royUK** · 04-29-2010, 01:20 AM

Try

=(HOUR(A1))*3600+MINUTE(A1)*60+SECOND(A1)

**olive** · 04-29-2010, 01:35 AM

Hi RoyUK,

Thanks, that worked on two of my documents, but not on my third. I just get #VALUE!

I've checked the formatting, but still getting that error. Any ideas?

Thanks
Jen

**DonkeyOte** · 04-29-2010, 03:42 AM

Try

=IF(ISNUMBER(--A1),A1*86400,"")
format as General / Number

If you get a Null the implication is that the value (col A) is not a true Time value / string (ie can not be treated/coerced as numeric)

On an aside you could also see the seconds by formatting originals (or copies thereof) as [ss]