Thread: Datediff()
View Single Post
 
Old 06-22-2018, 10:48 PM
otuatail otuatail is offline Windows 7 64bit Office 2007
Competent Performer
  
Join Date: Jun 2012
Posts: 245
otuatail is on a distinguished road
Default Datediff()
How do Iget date diff in hours or minutes. Can only get days difference
=DATEDIF(INDIRECT(H1),INDIRECT(I1),"d")

Surly "h" and "mm" should work here..

Also need to divide by rows difference.
Reply With Quote