Hi
I need help in calculating the DAte difference in excel for example in the following two dates in minutes
6/04/2010 10:35
9/04/2010 9:10
Hi
I need help in calculating the DAte difference in excel for example in the following two dates in minutes
6/04/2010 10:35
9/04/2010 9:10
Try
=(B2-A2)*24*60
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
or
=B2-A2 with result cell custom formatted to [mm]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thanks a million , it worked very well