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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - 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