Thread: [Solved] DateDiff gives error when working after 24 hours
View Single Post
 
Old 07-18-2012, 12:50 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You might also consider:
=B1+(INT(A2)-INT(A1)>0)
or:
=B1+(INT(A2-A1)>0)
in B2 and copy down. With the second forumla, a difference of 24hrs will count as a 'day' difference, whereas your's treats them as different if only a 1-second difference results in a date change. As you'll see, no IF test is required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote