Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 In column J put the formula: =MID(B1,FIND("″",B1,FIND(F1,B1))+1,1) In column K put the formula: =C1 + (D1/60) + (E1/3600) In column L put the formula: =G1 + (H1/60) + (I1/3600) In column M put the formula: =IF(F1="N", K1, K1 * -1) In column N put the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 array('year','month','week','day','hour','minute','second'); // set unit values $a_UnitValues = array( floor($v_Seconds / 31536000), floor(($v_Seconds % 31536000) / 2592000), floor(($v_Seconds % 2592000) / 604800), floor(($v_Seconds % 604800) / 86400),...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 / 86400 IfInString, ThisDays, . ThisDays:=SubStr(ThisDays, 1, InStr(ThisDays, ".")-1) ThisHours:=(Mod(val, 86400)/3600) IfInString, ThisHours, . ThisHours:=SubStr(ThisHours, 1, InStr(ThisHours, ".")-1) ThisMins:=(Mod(val, 3600)/60) IfInString, ThisMins,...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 A_Now, FinalDate, "s" ) ThisManyMinutes:=Floor(ThisManySeconds/60) ThisManyHours:=Floor(ThisManySeconds/3600) ThisManyDays:=Floor(ThisManySeconds/86400) ThisManyWeeks:=Floor(ThisManySeconds/604800) ThisManyMinutesRemainder:=Mod(ThisManySeconds, 60)...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 = returnTime( seconds_elapsed ); } } function returnTime( s ){ hours = parseInt(s / 3600); s = (s % 3600); minutes = parseInt(s / 60); s = (s % 60); seconds = parseInt(s); str1 = ("0" + hours).slice(-2); str2 = ("0" + minutes).slice(-2); str3 = ("0" +...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: *

Convert seconds to total time in PHPhttps://www.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":"; $total_time.=str_pad(intval(($total_seconds/60)%60),2,"0",STR_PAD_LEFT).":";...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 "Dataset2")) - CDate(First(Fields!REPORTSTARTTIME.Value, "Dataset1")) ).ToString ), 1, 2 )*3600) + (Mid( CStr( ( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) - CDate(First(Fields!REPORTSTARTTIME.Value, "Dataset1")) ).ToString ), 4, 2 )*60) + Mid(...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Cheat Sheet for mySQL vs t-SQLhttps://www.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 '%d/%m/%Y') CONVERT(varchar, getdate(), 103) Time to Seconds TIME_TO_SEC(now()) (DATEPART(hour, getdate()) * 3600) + (DATEPART(minute, getdate()) * 60) + (DATEPART(second, getdate())) Seconds to Time SEC_TO_TIME( seconds ) CONVERT(varchar, DATEADD(ms,...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 if(file_exists($api['jwt']['token']['file'])){ $expiry_time = filemtime($api['jwt']['token']['file']) + 3600; $diff = $expiry_time - time(); $api['jwt']['token']['minutes'] = floor($diff/60); } 6a. Use existing Access Token This if else statement simply...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 v_MilliSeconds := Floor( v_MicroSeconds / 1000) v_Seconds := Floor( v_MilliSeconds / 1000) v_CalcHours := Floor( v_Seconds / 3600 ) v_CalcMinutes1 := v_Seconds / 60 v_CalcMinutes2 := Mod( v_CalcMinutes1, 60 ) v_CalcMinutes := Floor( v_CalcMinutes2 )...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *