Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 time, eg. 5mins). 30 minutes for us translates to 0.07 in person days (a person day being 7 hours and 24 minutes or 26640 seconds). How? The answer was always going to be a convoluted formula just to convert it into minutes and then format the resulting...

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

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to...

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

Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 it's tinged gold as it should be. Flip the pancake over with a pan slice or palette knife - the other side will need a few seconds only - then simply slide it out of the pan onto a plate. Stack the pancakes as you make them between sheets of greaseproof...

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

Passwords: Did-you-knowhttps://www.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 sessions; and any wifi keys used in your wireless connections. All the software can run off a USB key needing only a few seconds to connect to your computer and to automatically download all the passwords. (source: NirSoft Recovery Tools 01/2008) 4 main...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 is available from Connector/NET version 5.1.4. Specifying connection attempt timeout Use this one to specify the length in seconds to wait for a server connection before terminating the attempt and receive an error....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 years (required tweaking twice a year). Then there were the error logs... some 20000 errors per use of a feature over 4 seconds. Do some developers never check the errors log? By the time, I started maintaining the project, a revamp had been agreed with...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 TimeEnd datetime NOT NULL Time report finished running? Need to check what finished? TimeDataRetrieval int NOT NULL Milliseconds spent retrieving the data. TimeProcessing int NOT NULL Milliseconds spent processing the report. TimeRendering int NOT NULL...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 s.StaffUserID AS 'UserID', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) AS SecondsElapsed FROM StaffActivities s WHERE WEEKDAY(s.DateTimeCreated)=0 AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value...

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

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 work that day. EndTime will be the latest someone works that day. Time is recorded by tasks with an actual duration in seconds (eg. "Monday morning, I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.",...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 : :: /R:n :: number of Retries on failed copies: default 1 million. /W:n :: Wait time between retries: default is 30 seconds. /REG :: Save /R:n and /W:n in the Registry as default settings. /TBD :: wait for sharenames To Be Defined (retry error 67). ::...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Fixed Bug: Parameter initialization and class array correction (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 2.0.2 -...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 that mess but the 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 in the Creator system....

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 { // 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 = r_Api.Access_Token; }...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 { l_CheckJob = " ".leftPad(5).replaceAll(" ",",").toList(); for each index v_CheckJob in l_CheckJob { // // delay for 10 seconds r_Delay1 = invokeurl [ url :"https://httpbin.org/delay/10" type :PUT ]; // // now export the data from the job v_Endpoint5 =...

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

SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 of the day. Why? Take any SSRS report, if one of us was the first 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...

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