Converting name to standard time

[sridharKj]

Hi

I am preparing the time sheet of employees. I need help from you regarding of flow on standard time when the name is typed on the particular cell?

Eg:

If I type the name John in one cell then I need 8hrs to flow on the next cell.

Hope you understand my problem. Kindly guide me on this.

Regards

[swatsp0p]

Hi, sridharKj. How do you know that "John" = 8 hours? Does "Bill" = 8 hours also?

I would assume that each name could have a different value. If that is the case, I would set up a table that could be searched via the VLOOKUP function. So, on another sheet create a table with all the Names in one Column and the associated times in the next column. Sort this range Ascending by the name column and Name this Range "Times" (for ease of writing the formula).

On your main page, assuming your Names will be listed in Column A and you want the associated hours in Column B, in B2 place this formula:

=VLOOKUP(A2,Times,2,0)

This will find the name you listed in A2 in your Times table and return the associated time. If the name cannot be found, "N/A" will be returned.

Good Luck

Bruce