Combining (match and append) data from two sheets into third in VBA (2003) please

[dawatcher]

Hi All,

First, this forum has taught me a lot so thank you to all contributors.

I have tried to code a particular issue, but cannot get working code, so I thought I'd put it out there to see if anyone can help (I have tried searching the forum but was unable to find a specific match to my requirements).

To simplify the matter:
Excel 2003 workbook with 3 sheets - Normal, Overtime, and Combined.

Part 1 is simply to copy/paste all records from Normal to Combined - that's done.
Part 2 where I got stuck was - for every record in Combined: Search Overtime sheet for matching Name,
and if found, update the Hours Worked column on the Combined sheet so they total the Hours from Normal + Overtime if matched.

Real app is much more data, but once I understand how to do it, I will adapt it.

One side question:
The time data I work with is in the format [hh]:mm:ss - but I also have data in decimal format, e.g 25.00.
What is the best way to convert the decimal value to [hh]:mm:ss? I tried just changing the format but it came up with a non-sensible value?

Hope the very basic demo attached is enough.

Thank you all for your assistance.

[rylo]

Hi

1) Some quick code to do the summation

Please Login or Register  to view this content.

2) What does the 25.00 represent? 25 hours 0 minutes? 25.0 minutes?

rylo

[dawatcher]

Wow - that was quick! Will try it and let you know. As for the 25.00 it is 25 hours.

Thank you very much indeed!

[dawatcher]

Works like a charm! Cannot thank you enough!

[rylo]

Hi

For the hours thing, try something like
=TIMEVALUE(TEXT(E2/24,"hh:mm"))
where the 25.00 was in E2.

rylo

[dawatcher]

Thanks Rylo, but when I tried it, it returned 0.041666667

Am I missing something?

[rylo]

Hi

What would you expect it to return? What do you want to do with it?

rylo

[dawatcher]

Sorry - probably wasn't clear. If the cell has 25.00 then I would like to turn it into 25:00:00 and so forth.

Appreciate the assistance.