Lost you on your new query ..

Can you upload a sample file (in .xls format) using a free filehost,
then post a link to it here?

For example, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

(Desensitize your sample as appropriate)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000, Files:358, Subscribers:55
xdemechanik
---
"JC-PS" wrote
Thanks, have been useful. Right now I'm looking for a formula if I
have a column for a remark like "No Paid" using a letter W in
substitute, but at the same time may discriminate from others like M or
F, and give a result of hours used for those kind of license on a
column beside this one.

.....monday tuesday wednesday ..................Use Hrs---License Letter
......L3.2.......W...........F.................... ...............7.2.............W
or
..... -
........M...........W............................. .....7.2.............M
.................................................. ............(and).7.2.............W
this both at the same day (could be on different column).