Search - Joel Lipman .Com

1. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ...; Created on 27 April 2012
2. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... System_Date_Time_End, Agent_Date_Time_Start, and Agent_Date_Time_End: // defaults v_AppointmentDuration = 30; // // get customer's requested time v_CustomersRequestedTime = input.Customers_Requested_Time.toTime(); v_CustomerTimeZoneName ...; Created on 07 December 2021
3. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; ... = ; m_Params = { "name": "My Happy Project", "flag": "internal", "milestone_id": 98765432109876540, "tasklist_id": 78901234567890130, "person_responsible": "20211234567", "duration": "1", ...; Created on 17 June 2021
4. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... Return fex } Usage v_MyMediaFile := "C:\Users\Public\Music\Sample Music\Maid with the Flaxen Hair.mp3" a_MediaObject := Filexpro( v_MyMediaFile,, "System.Media.Duration" ...; Created on 07 August 2020
5. Zoho Deluge: Check Time Booking Slots: / Zoho /; ... a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for each thisRecord in allRecords { thisRecord_StartTime ...; Created on 05 December 2018
6. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... News: localized on map (use API) - News: cache for map (+offline mode) - News: cache for later reading - Pilot: view top configurations for best distance/duration - Pilot: view top rated equipment - ...; Created on 24 October 2014
7. Generate a Timesheet in MySQL: / MySQL /; What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with ...; Created on 05 December 2013
8. AwStats Data Parser (ADP): / Product Documentation /; ... Duration (this month) Pages-URL (Top 25 this month) Operating Systems (Top 10 this month) Browsers (Top 10 this month) Connect to site from (Referers this month) Search Keyphrases (Top 10 ...; Created on 03 April 2013
9. Slideshow div layer through a window: / MooTools Framework /; ... this, { // duration of 1 second for transition 'opacity': 1,'top': 0,'left': v_left_most,'height': v_win_height,'width': v_win_width }); }).chain(function(){ this.start.delay(1, this, { // ...; Created on 11 September 2012
10. Convert seconds to total time in PHP: / Personal Home Page /; What? This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know ...; Created on 31 January 2012
11. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... AS ActivityDate, MIN(s.DateTimeCreated) AS DataFrom, MAX(s.EstimateTimeFinish) AS DataTo, SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish) - TIME_TO_SEC(s.DateTimeCreated))) AS ActivityDuration, ((SUM(TIME_TO_SEC(s.EstimateTimeFinish) ...; Created on 24 August 2011
12. Difference between two dates - the midnight hour: / Web-Development /; I might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on ...; Created on 06 April 2011
13. Developer's Checklist: Taking over a projec: / Web-Development /; ... disabilities and assist the students for the duration of their course. It had to allow for synchronizing with the official student record system and timetabling system (done via file upload). It included ...; Created on 01 March 2011
14. Countdown: Created on 30 December 2018
15. Homepage (default): Created on 10 January 2018
16. Header (Transparent): Created on 01 January 2018
17. Header (Flex): Created on 30 December 2017
18. Header (Centered): Created on 17 April 2017
19. Header (Adspace): Created on 17 April 2017
20. Gallery: Created on 17 April 2017