Hello,

I hope someone can assist me with this macro, I'm fairly new to this stuff, and I'm trying to learn, but have hit a brick wall.

The problem: I have the macro read a time on a different sheet - format is hh:mm:ss, and I'm trying to get a output in seconds. It has to be in an array as I have all kinds of data all over the place in the feeder sheet which the array searches, collects and then outputs..

My problem is with either one (or both) of these 2 lines in the macro..

Either:
WinArrData(F10, 4) = (Hour(Cells(BBcount, "Q").Value) * 3600 + Minute(Cells(BBcount, "Q").Value) * 60 + Second(Cells(BBcount, "Q").Value)) + WinArrData(F10, 4)
or

Cells(WinArrCell(F11), "I").Value = Format(Int(WinArrData(F11, 4) / 3600), "#,##0") & ":" & Format(Int((WinArrData(F11, 4) - (3600 * Int(WinArrData(F11, 4) / 3600))) / 60), "00") & ":" & Format(WinArrData(F11, 4) - (Int(WinArrData(F11, 4) / 3600) * 3600 + Int((WinArrData(F11, 4) - (3600 * Int(WinArrData(F11, 4) / 3600))) / 60) * 60), "00")
If the input is 00:16:08, the output is suppose to be 986, however I get 1489 from one of the above lines (I'm not sure which line)..

Can anyone assist please??

Thank You