faustf Posted November 7, 2011 Share Posted November 7, 2011 hi guy i wanna do a difference of 2 hours example start hour 12:56 AM finish 22:32 PM how can do this difference whit conversion in milliseconds ??? thanks Link to comment Share on other sites More sharing options...
water Posted November 7, 2011 Share Posted November 7, 2011 You could use function _DateDiff. 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...
faustf Posted November 7, 2011 Author Share Posted November 7, 2011 i have other questions why if i use this script have 0 like results ?? #include <Date.au3> global $i,$v,$c,$b $i ="1970/01/01 " $v="13:00:00" $c= "1970/01/01" $B="16:00:00" ; Calculated the number of seconds since EPOCH (1970/01/01 00:00:00) $iDateCalc = _DateDiff( 'n',$I&$V,$C&$ ;$iDateCalc =$iDateCalc * 0.52 MsgBox( 4096, "", "Number of seconds since EPOCH: " & $iDateCalc ) Link to comment Share on other sites More sharing options...
faustf Posted November 7, 2011 Author Share Posted November 7, 2011 i would do diff only for a date go in one varia ble and only for time in second variable Link to comment Share on other sites More sharing options...
water Posted November 7, 2011 Share Posted November 7, 2011 (edited) Because $c= "1970/01/01"needs a space character at the end like $i has. _DateDiff('n') returns the number of minutes. Use "s" to get the seconds. Edited November 7, 2011 by water 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...
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