Please excuse the long subject title, I coulnd't word the topic any other way.

I'd like to combine these two formulas

1. G2=VLOOKUP(L2,'Avaya Data'!$B:$O,3,FALSE)
2. Z2=("00"&G2)*1

Im importing call data in General format, which comes in such as ".80138" and sometimes it comes in ":18".
You can change ".80138" to custom hh:mm:ss which changes it to 19:14:00 but it doesn't change the ":18" to a uniform 00:00:00 format.

So to get cell G2 in correct format I have been doing the following:

Z2=("00"&G2)*1
Format Change: Custom hh:mm:ss
Copy
Paste Special, number and format into cell G2

Unfortunately its hard to automate this process as the rows of data are constantly changing with new associates. So basically what Im asking is how I can combine Formula 1 with Formula 2 in one formula.

Thank you for your time.