scottyyboyy
New member
- Joined
- Aug 13, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
hi all please help,
i have a logging in spread sheet form members of staff but what i want to know is:
if cell b2 has 08:15 and cell c2 is blank because they forgot to log out how can i put a formula in c2 to put a default time of of 15 mins in so c2 shows 08:30
can this be done.
thanks in advance
i have a logging in spread sheet form members of staff but what i want to know is:
if cell b2 has 08:15 and cell c2 is blank because they forgot to log out how can i put a formula in c2 to put a default time of of 15 mins in so c2 shows 08:30
can this be done.
thanks in advance