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

05 December 2013 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 EPM (Microsoft Enterprise Project Management) more and more....

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 0 - v_win_width; var v_right_most = 0 + v_win_width + 1; // setup slide 1 onload var fx_slide1 = new Fx.Morph('slide_01', {duration: 1000,transition: Fx.Transitions.Quart.easeOut}); $('slide_01').setStyle('background-image',...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

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 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 --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 Music\Maid with the Flaxen Hair.mp3" a_MediaObject := Filexpro( v_MyMediaFile,, "System.Media.Duration" , "System.Audio.ChannelCount" , "System.Audio.Compression" , "System.Audio.EncodingBitrate" , "System.Audio.Format" ,...

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

Zoho Deluge: Check Time Booking Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90;...

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

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 System_Date_Time_Start, 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();...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 "internal", "milestone_id": 98765432109876540, "tasklist_id": 78901234567890130, "person_responsible": "20211234567", "duration": "1", "duration_type": "hrs", "start_date": "11-12-2021", "end_date": "12-12-2021", "percent_complete": "0",...

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

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

01 March 2011 Needs group. These are staff who take lecture notes for people of all 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...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 AS DataTo, SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish) - TIME_TO_SEC(s.DateTimeCreated))) AS ActivityDuration, ((SUM(TIME_TO_SEC(s.EstimateTimeFinish) - TIME_TO_SEC(s.DateTimeCreated)))/26640) AS PersonDays, CONCAT(r.CapexCode, ' - ',...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 (per hour this month) Countries (Top 25 this month) Hosts (Top 25 this month) Robots/Spiders (Top 25 this month) visits Duration (this month) Pages-URL (Top 25 this month) Operating Systems (Top 10 this month) Browsers (Top 10 this month) Connect to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 - News: cache for map (+offline mode) - News: cache for later reading - Pilot: view top configurations for best distance/duration - Pilot: view top rated equipment - Pilot: rate other configurations (looks and performance) - Pilot: report a location as...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 doesn't like more than a 500Mb file attachment; and no more than 10 files at a time. I have a 1.5 Gb video which has a duration of 5.5 hours. I struggled with this and ultimately used VOSK but I'm leaving the instructions here in case it works for you....

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