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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>