How to write the time by entering "1520" so that it will be converted to "15:20" without entering a colon?

S

S

Sergey Varnachev2018-10-13 11:16:13

Google Sheets

Sergey Varnachev, 2018-10-13 11:16:13

How to write the time by entering "1520" so that it will be converted to "15:20" without entering a colon?

How to write the time by entering "1520" so that it will be converted to "15:20" without entering a colon?
This means the set time format "00:00", but I don't want to enter the separator every time.
UPD: better range. The desired format is "15:20 - 15:50", and write "15201550".

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)

D

Dimonchik, 2018-10-13
@dimonchik2013

https://webapps.stackexchange.com/questions/62586/...

Similar questions

S

Sergiy Marishchuk2021-07-30 17:46:12

How to find files that do not exist, having lists? 1Reply

L

lockiz2021-08-01 00:54:35

How to withdraw (income) - expenses by month? 1Reply

P

paroletatel2021-08-04 23:34:28

How to implement a table selection from Google Drive in a window, like in the built-in "Open" function? 1Reply

K

kornilov-s2015-12-13 15:13:25

How to create a script that will send notifications about changes in a table? 2Reply

S

Sergey Kalinkin2018-04-23 03:27:44

Google spreadsheets, how to make adding values from multiple cells into one cell? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question