Protecting column in worksheet

Solved/Closed
Nav - Jun 4, 2010 at 11:05 AM
 Saky - Jun 17, 2010 at 09:37 AM
How to protect only one particular column in worksheet?

3 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0
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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0
Thanks Riz, this code works perfect!!

Thanks a million!!
0