Time Issue

[jskushawah]

1- I have a range of time values, but when I try to sum them, the total is never greater than 24 hours?


2- How can I protect formulas from being deleted or changed?

 

[sdsurzh]

Hi,


1. Change the format to [h]:mm:ss

2. select the particular cells that you want to hide the formula. select format cells the select protection and check locked and hidden. Then protect the sheet.


Thanks,

Suresh Kumar S

 

[jskushawah]

Thanks Suresh...