Need to determine the elapsed Minutes between 2 dates in excel

[EasyButton]

The DateDiff("n",... function does not work in excel for Minutes.
Does anyone know How i can determine the elapsed Minutes between 2 dates?

Thanks,

 

[bj]

maybe
=(date1-date2)*24*60

 

[Jock]

Try this:
A1 = 1st date and time (Format dd/mm/yyyy hh:mm)
A2 = 2nd date, formatted the same.
B2 - A2-A1 (formatted [mm])

hth

 

[Toppers]

=(date1-date2)

format cell as [mm]