Worksheet that records employees time for payroll

**gman1729** · 09-14-2013, 08:06 AM

I am trying to setup a worksheet that records employees time for payroll. We have 3 categories for days off, personal, vacation, and sick. What I would like to do is input 10p for a 10 hour personal day and have Excel record the 10 hours in the correct cell. Is there a formula that will recognize the P and record the 10 hours if there is a P otherwise it will show 0?

**jeffreybrown** · 09-14-2013, 08:16 AM

Hello & Welcome to the Forum,

One possibility...

	A	B	C
1	11v	0	B1: =IF(RIGHT(A1)="p",SUBSTITUTE(A1,RIGHT(A1),"")+0,0)
2	10p	10

**gman1729** · 09-14-2013, 08:23 AM

That worked great. If I wanted it to add the personal days for the week would i just put A1:A7?

**jeffreybrown** · 09-14-2013, 08:38 AM

I'm not 100% following so could you put together a sample with showing what you want and the results?

There could be many different ways this could be done.