Problem with Time Output from Array.

[cgatlan]

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:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

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

[shg]

Assuming F10 is a variable (and not a misused cell address like it looks), then to convert from an Excel date/time to seconds,

Please Login or Register  to view this content.