ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "DATEDIFF" LOCATION IN EXCEL 2007 (https://www.excelbanter.com/excel-worksheet-functions/169761-datediff-location-excel-2007-a.html)

dickvw

"DATEDIFF" LOCATION IN EXCEL 2007
 
i AM ATTEMPTING TO DO AN ELAPSED TIME CALCULATION USING THE "DATEDIFF"
FUNCTION SUGGESTED IN SEVERAL POSTINGS ON THE DISCUSSION GROUP. WHERE DO I
FIND IT?
--
Grateful

David Biddulph[_2_]

"DATEDIFF" LOCATION IN EXCEL 2007
 
One F, not 2, if you are looking for the Excel function.
But don't look for it in Excel help or the function wizard, as it hasn't
been there since Excel 2000.
If you need info, look at http://www.cpearson.com/excel/datedif.aspx

If you really do want datediff with 2 Fs, that's in VBA.

And please don't SHOUT.
--
David Biddulph

"dickvw" wrote in message
...
i AM ATTEMPTING TO DO AN ELAPSED TIME CALCULATION USING THE "DATEDIFF"
FUNCTION SUGGESTED IN SEVERAL POSTINGS ON THE DISCUSSION GROUP. WHERE DO
I
FIND IT?
--
Grateful





All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com