Forum Discussion
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 |
- =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.- 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- Try =SI(A1>0,30,0)
Do NOT put the 30 in quotes.
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
