Assuming minutes is required, the following 45 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: *
-
CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want to add 10 minutes to a date/time field in ZohoCRM and wanted a refresher for use in a client system. The usual error is something similar to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
true); $response = curl_exec($ch); curl_close($ch); $output = json_decode($response, true); return $output; } 5. Get Minutes Remaining on cached token So usually an access token will last for 60 minutes, in this example, we are going to store the token...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
of person days in the cross-join. Why? Currently the smallest bookable time by low-level tape monkeys and techies is 30 minutes (Managers it would appear can book whatever time, eg. 5mins). 30 minutes for us translates to 0.07 in person days (a person...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
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 to convert: A B -------------------------------------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
hour clock) zero padded 13 %p locale's upper case AM or PM (blank in many locales) PM %P locale's lower case am or pm pm Minutes %M MM minutes 20 Seconds %s seconds since 00:00:00 1970-01-01 UTC (Unix epoch) 1309785651 %S SS second 00–60 (The 60 is...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
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 7...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
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 that...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
off time from 0.4 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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: *
-
and basil. This dish may be served hot or at room temperature. Use store-bought vinaigrette or make your own. Prep Time: 10 minutes Cook Time: 5 minutes Ingredients: 1/4 teaspoon dried garlic powder 1 package (10 ounces) plain couscous 1/2 cup sun-dried...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
form and choose Modified_Time Run this process on condition "Attached Files in CRM equals false" Execute Workflow "After 2 Minutes" Repeat Interval = Once Name the workflow > Create Workflow Give it the code // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
v_TimeHour = ((v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 / 60).round(0).leftpad(2).replaceAll(" ", "0"); v_TimeMinutes = ((v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 % 60).round(0).leftpad(2).replaceAll(" ", "0"); v_HoursHHmm =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
with a reminder in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to figure out so I don't spend so long the next time I have to do it. The use-case scenario here is that when an appointment...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= v_CustomerOffset.subString(0,1); v_CustomerHours = v_CustomerOffset.subString(1,3).toLong(); v_CustomerMinutes = v_CustomerOffset.subString(4,6).toLong(); if(v_CustomerPlusMinus == "+") { input.GMT_Date_Time_Start =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= message.trim(); l_Messages = List(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last 10 minutes v_MinutesAgo = 10; v_FromTime = zoho.currenttime.subMinutes(v_MinutesAgo).toLong(); v_TillTime = zoho.currenttime.toLong() /...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
than drive the commute back and forth again, I took my previous biscuit box out (a Dell MFF Optiplex 7070) and spent 30 minutes connecting monitors and the logitech receiver for my keyboard (which was a Logitech keyboard for Windows - keys switched for...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
thick batter. 2. Melt the butter in a thick based non-stick frying pan. Spoon the mixture into small rounds. 3. Fry for 2-3 minutes on each side until golden. 4. For the caramel sauce, in a hot pan, add the butter and sugar and cook for 3-4 minutes....
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
= Map(); v_Message = message.trim(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last 10 minutes v_MinutesAgo = 10; v_FromTime = zoho.currenttime.subMinutes(v_MinutesAgo).toLong(); v_TillTime = zoho.currenttime.toLong() / 1000;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
01:00:00 The next function usually accompanies the above one. It will basically convert seconds into days, hours, minutes, etc.: FormatSeconds(val) { IfInString, val, - { Month:=SubStr(val, 8, 3) Month:=Month * 1...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB