Datediff()

		Microsoft Office Forums > Microsoft Excel > Excel
Datediff()

FAQ

Thread Tools

Display Modes

06-22-2018, 10:48 PM

otuatail

Windows 7 64bit Datediff()

Office 2007

Competent Performer

Join Date: Jun 2012

Posts: 245

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DateDiff gives error when working after 24 hours	TimTDP	Excel	3	07-18-2012 12:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:30 PM.