PDA

View Full Version : Solved: DATE Difference



rahul_r79
03-17-2010, 03:52 PM
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

xld
03-17-2010, 04:57 PM
Try

=(B2-A2)*24*60

mdmackillop
03-18-2010, 06:43 AM
or
=B2-A2 with result cell custom formatted to [mm]

rahul_r79
04-06-2010, 11:52 PM
Thanks a million , it worked very well