Microsoft Office Forums - View Single Post - [Solved] DateDiff gives error when working after 24 hours

Thread: [Solved] DateDiff gives error when working after 24 hours

View Single Post

Old

07-17-2012, 09:06 PM

TimTDP

TimTDP is offline

TimTDP uses Windows 7 64bit

Windows 7 64bit TimTDP uses Office 2010 32bit

TimTDP uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

The original poster

Join Date: Apr 2012

Posts: 47

TimTDP is on a distinguished road

Default

This worked:

=IF(INT(A2) =INT(A3),B2,B2+1)

Reply With Quote