Mucho Posted March 16, 2011 Share Posted March 16, 2011 I have the following code that calculates the hours since the file's creation. How do I express it in minutes instead. $FILE = "J:\Report.txt" If FileExists("J:\Report.txt") Then $TIME = FileGetTime($FILE,0,0) $TIME1 = $TIME[0] & "/" & $TIME[1] & "/" & $TIME[2] & " " & $TIME[3] & ":" & $TIME[4] & ":" & $TIME[5] $TIME2 = _NowCalc() If _DateDiff("h",$TIME1,$TIME2) < 12 Then RunWait("J:\Print.exe") EndIf EndIf I appreciate all help. Thanks in advance. Link to comment Share on other sites More sharing options...
Andreik Posted March 16, 2011 Share Posted March 16, 2011 (edited) I think for minutes, $sType parameter of function _DateDiff() should be "n" not "h" Edited March 16, 2011 by Andreik When the words fail... music speaks. Link to comment Share on other sites More sharing options...
water Posted March 16, 2011 Share Posted March 16, 2011 The answer is already in your script! Change _DateDiff("h",$TIME1,$TIME2)to_DateDiff("n",$TIME1,$TIME2) My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Mucho Posted March 16, 2011 Author Share Posted March 16, 2011 Thanks to Andreik and Water. LOL, Andreik, you gave me the original code quite long ago in correctly helping with my question. I'm a total novice. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now