lookup + convert time to decimal

anyone????

Hi there. If I understood what you are trying to do, I believe a vlookup would do it. For your example with Keith, this worked for me.
= VLOOKUP(B7,L$7:P$28,5,TRUE)

So how you would use it. Go to cell E7 and type the above. You will then drag that down through all your cells below E7 You will also need to change the cell format to "Time" and select the "13:30:55" one. Hope that helps!

im getting #N/A
=(INT(N42)*24+HOUR(N42)+ROUND(MINUTE(N42)/60,2)) Found this to convert time to decimal

You get #N/A errors as there is some names which do not appear o your data list, eg 1A-Bill
paste this into cell E4 and copy down till the end of your list,
= IF(ISERROR(VLOOKUP(B4,L$7:P$28,5,TRUE)),"",(VLOOKUP(B4,L$7:P$28,5,TRUE)))

format the time cells you want using "format cells, time".

take a look at the file i attached, see if it's what you are after

Getting very close...everything from E:19 down has times that should not be

i notice on your sheet in the hours , column P Tammy's hours also have a date next to them, is that correct ??