Protecting column in worksheet
Solved/Closed
Related:
- Protecting column in worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- You've tried to log in too many times. to protect your account, a temporary block has been placed on logging in. please try again later. - Facebook Forum
- Facebook error - Facebook Forum
- We limit the number of times you can request security codes in a given amount of time. we have this limit to protect your security. for help accessing your account, learn more, or try again later. - Facebook Forum
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 4, 2010 at 11:11 AM
Jun 4, 2010 at 11:11 AM
You have to protect sheet for that. before you protect sheet make sure that unprotect all that you would like to be editable etc
Thanks Riz,
I have another quest. I Have two columns in my excel say Time in and Time out.
In the third colum i have to find out the time difference between the time in and time out column.
This can be done by a simple formula =C2-C1.
But if i enter my Time in at night 11:45PM and Time out at 12:15 AM the actual time gap in between is 30 mins, But the excel formulae doesn't work in such situations and it shows as one day delay.
Can this be sorted out??Please assist.
I have another quest. I Have two columns in my excel say Time in and Time out.
In the third colum i have to find out the time difference between the time in and time out column.
This can be done by a simple formula =C2-C1.
But if i enter my Time in at night 11:45PM and Time out at 12:15 AM the actual time gap in between is 30 mins, But the excel formulae doesn't work in such situations and it shows as one day delay.
Can this be sorted out??Please assist.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 5, 2010 at 06:18 AM
Jun 5, 2010 at 06:18 AM
Try this
=C2 - C1 + (C1>C21) * 24
You have to format the cell to time format to have hh:mm:ss
=C2 - C1 + (C1>C21) * 24
You have to format the cell to time format to have hh:mm:ss
