Microsoft Office Forums - View Single Post - Datediff()

Thread: Datediff()

View Single Post

Old

06-23-2018, 03:59 AM

otuatail

otuatail is offline

otuatail uses Windows 7 64bit

Windows 7 64bit otuatail uses Office 2007

otuatail uses Office 2007

Office 2007

Competent Performer

The original poster

Join Date: Jun 2012

Posts: 245

otuatail is on a distinguished road

Default

=DATEDIF(INDIRECT(H1),INDIRECT(I1),"d")/(ROW(INDIRECT(I1))-ROW(INDIRECT(H1))+1)

Datediff doesn't do hours and minutes

Reply With Quote