lookup + convert time to decimal

Need help.... i copy paste data to spreadsheet twice day containing hours employees worked (regular/not timeclock decimal)

these hours are in column P which get copy/pasted

i need to match the hours with the correct employee in column b

and enter (Converted timeclock hours) hours in colum E

(See Attached Sample sheet 3)

Any advice is greatly appreciated

Please forgive me i am excel noob!

Ty in Advance!




I found this... converts time to decimal =(INT(N45)*24+HOUR(N45)+ROUND(MINUTE(N45)/60,2))