How to do a work graph in MS Excel?

T

Thor

How do give single letters numerical equivalent? (MS Excel) im trying to do a
work graph.
I have filled some cols and rows like that
Example:
| Date | | Date | | Date | | Date | {etc}
|Working hours
Name 1.th june 2.th june 3.th june 4.th june {etc}
|
Peter J J G -
|

as in example J means 8 working hours, G means 6 working hours and - means a
day off. At the end should be some formula which sums all the working days to
exact hours.
I would be grateful if Someone could answer me by sending an e-mail to this
address: (e-mail address removed)

Sry for the typos.. havent use English language for 3 years :p
 
T

Thor

Thor said:
How do give single letters numerical equivalent? (MS Excel) im trying to do a
work graph.
I have filled some cols and rows like that
Example:
| Date | | Date | | Date | | Date | {etc}
|Working hours
Name 1.th june 2.th june 3.th june 4.th june {etc}
|
Peter J J G -
|

as in example J means 8 working hours, G means 6 working hours and - means a
day off. At the end should be some formula which sums all the working days to
exact hours.
I would be grateful if Someone could answer me by sending an e-mail to this
address: (e-mail address removed)

Sry for the typos.. havent use English language for 3 years :p

okey i have put on the internet a pic of sample graph please i really need
help someone?
this address below:
http://thor.msn.ee/stonia/kaardid/graph.gif?2
 
M

Max

Perhaps something like this ..

In B5:
=IF(B4="",0,VLOOKUP(B4,{"E",9.5;"G",9.5;"I",13;"J",12},2,0))
Copy B5 across to AE5
 
T

Thor

Max said:
Perhaps something like this ..

In B5:
=IF(B4="",0,VLOOKUP(B4,{"E",9.5;"G",9.5;"I",13;"J",12},2,0))
Copy B5 across to AE5

"",0,VLOOKUP there is some mistake ... excel gives me error for it.
Best for me would be that kind of formula that, when im doing new grapg
everymong different then just by typing for an example E then and the end of
line in working hours cell would appear 9,5hours, and when i keep adding
letters then the sum will growth
 
M

Max

"",0,VLOOKUP there is some mistake ... excel gives me error for it.

Think you need to change the commas to semicolons
in the formula to suit your continental Excel version,
perhaps try something like this in B5 over there:
=IF(B4="";0;VLOOKUP(B4;{"E",9.5;"G",9.5;"I",13;"J",12};2;0))
then copy B5 across to AE5
 
T

Thor

Re: Max
=IF(B4="";0;VLOOKUP(B4;{"E",9.5;"G",9.5;"I",13;"J",12};2;0))
then copy B5 across to AE5

I dont know what am i doing wrong or is something in this formula wrong, but
i cant get it to work :(

Maybe you could set-up somewhere a working graph_example or send it to my
e-mail:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top