View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default Need to determine the elapsed Minutes between 2 dates in excel

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

--
Traa Dy Liooar

Jock


"EasyButton" wrote:

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,