Assuming hours is required, the following 49 results were found.
-
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 Deluge. How? We're going to make use of the .toLong() function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_WorkNotes = ifnull(input.Work_Notes,""); v_TaskOrIssue = if(input.Type == "Task", "tasks", "bugs"); // // eval v_HoursDecimal = (v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 / 60; v_TimeHour = ((v_EndTime.toLong() - v_StartTime.toLong()) /...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
would appear can book whatever 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...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
%C cc century 00–99 Date %D mm/dd/yy 07/4/11 %x locale's date representation (mm/dd/yy) 07/4/2011 %F %Y-%m-%d 2011-07-4 Hours %l (Lowercase L) hour (12 hour clock) 1 %I (Uppercase I) hour (12 hour clock) zero padded 01 %k hour (24 hour clock) 13 %H hour...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
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 the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
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 we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds. We could have tried out some cool new DLL files for MS Windows 10 but we needed something lightweight...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2 schedules: one that runs on even hours and one that runs on odd hours to change this to every hour. It's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
void fn_Leads_FollowUpNonConverted(Int p_LeadID) Label: Fn - Leads - Follow Up Non Converted Lead Trigger: Triggered 24 hours after a lead is created. Purpose: Follow up when a lead is created and not converted within 1 day send an email and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
still attributed to them. Prepare for Go Live This migration script is not a silver bullet. It was created to take away the hours I know I would spend without it. This is not an upgrade; it is likely that your client may reconsider the template they are...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
(again) Check the clock has updated in your taskbar and close the window by clicking on OK Leave your computer for a few hours and see if it keeps the time... If the problem persists, try changing the system registry setting as per the below. If you...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
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 the same, but this is an example that I was coding and found to...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
again when more than n changes seen. /MOT:m :: MOnitor source; run again in m minutes Time, if changed. /RH:hhmm-hhmm :: Run Hours - times when new copies may be started. /PF :: check run hours on a Per File (not per pass) basis. /IPG:n :: Inter-Packet...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue is that if you use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the subdomain). I have had this working with the 2 CNAME records though. Some providers say this will take between 24-48 hours but I have often found that after a few hours, the effects have been propagated. A test I like to do is open the command-line...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Why? As developers, we're keep account of our time and we are currently logging time in our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_CustomerOffset = "+01:00"; // // calculate GMT v_CustomerPlusMinus = v_CustomerOffset.subString(0,1); v_CustomerHours = v_CustomerOffset.subString(1,3).toLong(); v_CustomerMinutes = v_CustomerOffset.subString(4,6).toLong(); if(v_CustomerPlusMinus ==...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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. Pre-amble...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *