Thank you this work. Take this one step further. What am I missing? My
formula isn't rounding.
=IF(AND(INT(StartDT)=INT(EndDT),NOT(ISNA(MATCH(INT (StartDT),
HolidayList,0)))),"0 days 0 hours", IF(INT(StartDT)=INT(EndDT),
"0 days " & ROUND(24*(EndDT-StartDT),2)&"hours",
MAX(NETWORKDAYS(StartDT+1,EndDT-1,HolidayList),0)+
INT(24*(((EndDT-INT(EndDT))-(StartDT-INT(StartDT)))+
(DayEnd-DayStart))/(24*(DayEnd-DayStart)))&
" days "&MOD(ROUND(((24*(EndDT-INT(EndDT)))-24*DayStart)+
(24*DayEnd-(24*(StartDT-INT(StartDT)))),2),
ROUND((24*(DayEnd-DayStart)),2))&" hours "))

My version of excel isn't current - I think it is 1998.


"JulieD" wrote:

Hi

you can apply worksheet protection to the sheet
first select the cells you want people to access and choose format / cells /
protection & untick locked
next choose tools / protection / protect sheet
- you can add a password, if required.
now people can only change the cells that you "unlocked" above

hope this helps
Cheers
JulieD

"internet team" wrote in message
...
Is there a way to lock formulas? I would like other users to be able to
input info, but not be able to change any of the formulas.