Microsoft Office Forums - View Single Post - [Solved] Automatic, Dependent Cell Values

Thread: [Solved] Automatic, Dependent Cell Values

View Single Post

Old

08-26-2011, 03:45 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2007

Catalin.B uses Office 2007

Office 2007

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

a simple idea is to set a blank column for users to enter extra time if needed, and complete the formula with this column
=IF(A1 <> "", A1 + TIME(2,0,0), "")
=IF(A1 <> "", A1 + B1 + TIME(2,0,0), "")

Reply With Quote