Need to determine the elapsed Minutes between 2 dates in excel
 

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,

Need to determine the elapsed Minutes between 2 dates in excel
 

maybe
=(date1-date2)*24*60

"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,

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,

Need to determine the elapsed Minutes between 2 dates in excel
 

=(date1-date2)

format cell as [mm]

"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,