会員登録(無料)
ログイン
Improve your skills, click here now!
HOME
Search
WordPress
Category
Twitter
Youtube
GoogleSpreadSheet

Google Spreadsheet How to calculate total operating hours (working hours) from the displayed time (hh:mm)

This method calculates work hours from the displayed time (hh:mm).Time clocked out - Time clocked inSo, let's subtract t...
2022.08.14
GoogleSpreadSheet
GoogleSpreadSheet

Google Spreadsheet Create parade charts and ABC analysis graphs from tables｜Priority Analysis

What is ABC analysis?ABC analysis is based on the concept that the top 20% of sales account for 80% of total sales, and ...
2022.07.18
GoogleSpreadSheet
Job

What are the types of businesses and occupations in hotels? About the type of business and occupation

In this issue, we will discuss the industries and occupations of hotels, hoteliers, hotel receptionists, innkeepers, etc...
2022.06.19
Job
GAS

 [GAS] Operational efficiency! How to Synchronize Value Data in Two Google Spreadsheets in Two Ways [1/2]

It's a familiar and convenient Google Spreadsheet, but this time it's a synchronization script?I will show you how to cr...
2021.12.08
GAS
GoogleSpreadSheet

[Google Spreadsheet] A convenient function to extract and display titles from the article list | IMPORTXML function

When you want to getall the pagetitlesfrom the list ofURLs at once, you can use the convenient function "IMPORTXML funct...
2021.09.26
GoogleSpreadSheet
GAS

[GAS] [PART1] Create and run a bot with LINEnotify that notifies LINE when a specific email arrives at Gmail and marks it as read

Anyway, these days I want to automate various things, but this time it is a method of "notifying LINE when a specific em...
2021.07.01
GAS
WordPress

[Cocoon] How to center the image caption | WordPress caption position

Although it is not limited to Cocoon themes, depending on the theme, the position of the caption placed in the image may...
2021.05.28
WordPress
GoogleSpreadSheet

[Google Spreadsheet] I want to count down the number of days left from a specified date! ｜DAYS function & NOW function

If you use Google Spreadsheet (commonly known as Google Sheet Spreadsheet), how many more days will it take to reach the...
2020.07.30
GoogleSpreadSheet
GoogleSpreadSheet

[Google Sheets] List of functions related to dates

We have compiled a list of functions related to "date" in Google Sheets!NETWORKDAYS.INTL=NETWORKDAYS.INTL(start date, en...
2020.06.08
GoogleSpreadSheet
GAS

[GAS] How to send data from your own inquiry form using Google Forms

Inquiry form creationUsually when you try to create a contact form1.2. Set up a server.Build a contact form in PHPI thin...
2019.10.15
GAS
Excel

[Introduction to EXCEL] Two methods to hide cells with values ​​in them

I want to hide it from the screen while keeping the value in the cell with EXCEL.It is a technique that can be used in s...
2019.08.08
Excel
GoogleSpreadSheet

[Google Sheets] How to use the Importrange function! Useful import functions

import range functionIt is useful whenyou want to pull out and display data from another Google Spreadsheet in Google Sp...
2019.07.06
GoogleSpreadSheet
GAS

GAS (Google ActionScript) “This application has not been verified” This application has not been verified by Google. This app has not been confirmed by Google.

This application has not been verifiedThis app has not been verified.This app has not been verified by Google. Please co...
2018.10.20
GAS
GoogleSpreadSheet

[Introduction to Google Sheets] What is Google Sheets?

What is Google SheetsGoogle Sheets is "an online spreadsheet app that allows you to create, format, and collaborate with...
2018.09.25
GoogleSpreadSheet