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 be...
=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.
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, 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 |