Search - Joel Lipman .Com

1. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; What? A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho ...; Created on 21 September 2021
2. Excel: convert degrees minutes seconds to decimal: / Excel /; What? A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want ...; Created on 06 November 2014
3. About 5 seconds worth of fun: / SharePoint /; What? Really not work related but if you know your sharepoint site: Custom Error http:///_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks. ...; Created on 21 November 2012
4. Convert seconds to total time in PHP: / Personal Home Page /; ... to properly convert seconds into total hours, minutes and seconds (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).":"; $total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); // ...; Created on 31 January 2012
5. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...; Created on 17 November 2011
6. AutoHotkey Format Date and Format Seconds: / AutoHotkey /; As you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it' ...; Created on 20 September 2011
7. Joomla Themes from a Photoshop Template Design in Seconds: / Joomla /; Create a working Joomla Template from your Photoshop PSD design in seconds. hf0Fovrm4Lc; Created on 21 September 2009
8. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
9. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... info "New Token Generated"; r_Api.Access_Token=r_eBayResponse.get("access_token"); v_AccessSeconds = r_eBayResponse.get("expires_in").toLong(); r_Api.Access_Token_Expiry=zoho.currenttime.addSeconds(v_AccessSeconds); v_Output ...; Created on 20 September 2021
10. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... a blank page. Their only workaround is wait about 30 seconds or more for the loop to automatically cut out and then they can use the interface again only to find it may crash again. In the background ...; Created on 19 September 2021
11. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... Shopify webhook payload is now in your Zoho Creator! Having used this for a while, we average about 5 seconds from when the Order is updated (with payment?) in Shopify to when it gets parsed and created ...; Created on 15 July 2021
12. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds ...; Created on 07 August 2020
13. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/"; v_StartIndex ...; Created on 04 May 2020
14. Convert Past Date to Time Ago in PHP: / Personal Home Page /; What? Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what ...; Created on 16 May 2019
15. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... really random, it involves getting the milliseconds from a time object. v_Uid = zoho.currenttime.toLong(); // returns something like 1557400230165 Method #1: 5 Randomly Selected Letters ...; Created on 09 May 2019
16. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
17. Pure JS - Display Time Elapsed & Remaining: / JavaScript /; What? This is an example of Javascript code to update and display the elapsed/remaining hours minutes and seconds in real-time. Why? I know there are a lot of articles out there that write about ...; Created on 30 October 2018
18. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... (by Miguel Isasmendi) - Fun Bug: Debug mode shows number of seconds this module adds.- Date Uploaded: Tue, 23rd Aug 2011 2.0.3 - Optimizing code- Date Uploaded: Sun, 21st Aug 2011 ...; Created on 07 September 2015
19. AHK Countdown Tooltip: / AutoHotkey /; ... ; TOTALS ThisManySeconds:=DateDiff( A_Now, FinalDate, "s" ) ThisManyMinutes:=Floor(ThisManySeconds/60) ThisManyHours:=Floor(ThisManySeconds/3600) ...; Created on 17 July 2014
20. SSRS No Delay for First Report of the Day: / SQL Server Reporting Services /; ... to run it on that day, it would take an additional 60 seconds to get with it and display the report. Any subsequent running of the report loaded it almost immediately. How? There are a few options ...; Created on 11 April 2014