# Time sheet How to add 30 (number to cell if the cell before has value

Occasional Contributor

# Time sheet How to add 30 (number to cell if the cell before has value

Time sheet How to add 30 (number to cell if the cell before has value

 9:05 17:05 9:00 17:00 9:00 17:00 9:00 17:00 9:00 17:00

Should become

 9:05 30 17:05 9:00 30 17:00 9:00 30 17:00 9:00 30 17:00 9:00 30 17:00
4 Replies

# Re: Time sheet How to add 30 (number to cell if the cell before has value

=if(a1<>"",30,"")

Assuming that "the cell before" means the one to the left of the cell in which this formula appears.

Seems a strange request, however, so I'd feel more comfortable with the answer if you could explain more fully what the context is.

# Re: Time sheet How to add 30 (number to cell if the cell before has value

Hi, this is for a timesheet, based on 7 days of week, if employee entered from a form times on monday trough friday, and none for saturday and sunday, I want a 30 ( break in minutes) to appear in the cell ( break), the one after start time

Can you look a the picture just sent, I have an error. I have a french excel

A                                                    B     Minute break                         C

 Monday 9:05 30 17:05 Tuesday 9:00 30 17:00 Wednesday 9:00 30 17:00 Thursday 9:00 30 17:00 Friday 9:00 30 17:00 Saturday Sunday

# Re: Time sheet How to add 30 (number to cell if the cell before has value

Hi, I have succeed with : =SI(A1>0;"30";"")

But when there is no value, it creates an error in the calculation of Total of hours/minutes
I would like that "" do not create such error

# Re: Time sheet How to add 30 (number to cell if the cell before has value

Try =SI(A1>0,30,0)

Do NOT put the 30 in quotes.