using excel to keep running total

[brilliantjimmyriddle]

I am excel illiterate, so I'm hoping that someone out there can help me. I have set up a payroll spreadsheet using excel. I would like to keep a running total each month of sick time used, vacation time used, holiday time used, etc. Each employee has 7 cells to the right of their name each week, one for each day of the week. We use codes prior to the number of hours worked. For example, if someone is working a 10 hour day and they call in sick, we list it as S10. If they come in and work 2 hours and then go home sick, we would list it as W8+S2. Is there anyway to write a formula that will scan all of the cells for cells that contain an "S" and then count the number of hours after the S. I would appreciate any help I can get with this problem.

 

[Yogi Anand]

I am excel illiterate, so I'm hoping that someone out there can help me. I have set up a payroll spreadsheet using excel. I would like to keep a running total each month of sick time used, vacation time used, holiday time used, etc. Each employee has 7 cells to the right of their name each week, one for each day of the week. We use codes prior to the number of hours worked. For example, if someone is working a 10 hour day and they call in sick, we list it as S10. If they come in and work 2 hours and then go home sick, we would list it as W8+S2. Is there anyway to write a formula that will scan all of the cells for cells that contain an "S" and then count the number of hours after the S. I would appreciate any help I can get with this problem.

Hi brilliantjimmyriddle:

Welcome to MrExcel Board!

Let us see, if I have understood you correctly ...

y040209h1a.xls
	A	B	C	D	E	F	G	H	I	J
1	Name	Sun	Mon	Tue	Wed	Thu	Fri	Sat		SickHours
2	a	0	8	8	S8	W8+S2	8	8		10
3	b	10	6	8	8	4	W4+S4	0		4
Sheet9

Is this what you are looking for?

 

[brilliantjimmyriddle]

That's exactly it!!!

 

[brilliantjimmyriddle]

Thank you so much! You don't know how much I appreciate your help.

 

[Yogi Anand]

Hi brilliantjimmyriddle:

You Are Very Welcome -- Now let Us Keep EXCELing!