Microsoft Office Forums - View Single Post - Datediff()

Thread: Datediff()

View Single Post

Old

06-23-2018, 12:23 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

when I format custom "[h]:mm" it display esxactly that
"[h]:mm"

Ok remove the quotes

What I need is to divide by the number of rows selected by
=INDIRECT(I1)-INDIRECT(H1)

Reply With Quote