How to do a work graph in MS Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
 
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
 
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
Click to expand...

"",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
 
"",0,VLOOKUP there is some mistake ... excel gives me error for it.
Click to expand...

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

---
 
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
Click to expand...

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]
 
Back
Top