Kapalı

Google Spreadsheet - Adjust formula to produce a better date/time format

Pay is $1 per solution.

I have other work as well.

I need a formula in the form of a script that I can tie to a Google Button.

After selecting a cell that I need to produce a current date and time for, I need the cell to populate with the correct date and time format regardless of the original formatting of the cell.

In this spreadsheet, for instance, the dates and times shown on row two (2) are correct while the one shown in C4 is incorrect.

https://docs.google.com/spreadsheets/d/1j9TisnEsnbzMR8u9IsLN4arvch7CvkHqvPkcevHWYTI/edit#gid=1639897763

Assistance is greatly appreciated.

Beceriler: Excel, Veri Girişi, JavaScript, Visual Basic, PHP

Daha fazlasını gör: datepicker date time format php, bash date time format space problem, due date email google spreadsheet, google spreadsheet script date, email due date google spreadsheet, google api date time, google spreadsheet and excel work in real time together, google spreadsheet last modified date, convert excel formula to google spreadsheet, sort by date in google spreadsheet, google spreadsheet array formula concatenate, date time format in smarty, jira jql date time format, https docs google com spreadsheets d 1mlr8b8fce8ce2behia3cainem2mdkshdijdrvvrggy0 edit usp sharing, https docs google com spreadsheets d 1wypb8_72e4pn0rawq3jf2bwc4n3xvlsieof8eclppro edit usp sharing, google spreadsheet date format dd/mm/yyyy formula, utc date/time format, docs.google com/spreadsheets/d/1rgsutpou9vw5lopfmixjbf2j0vorm5qdiuiullxz5ow/edit#gid=0, r date-time format, change date time format in php

İşveren Hakkında:
( 77 değerlendirme ) Waco, United States

Proje NO: #29067085

Bu iş için 9 freelancer ortalamada $3/saat teklif veriyor

superseoservice

Hi there, Good Day, I’ve checked the project details and I got it your requirement. I have more then 5 years experienced and completed so many several projects like this with 100% Client Satisfaction. I will be complet Daha Fazla

$3 USD / saat tutarından itibaren
(13 Değerlendirme)
4.4
yadavexpert53

Hi, I would like to on this project "Adjust formula to produce a better date/time format". For more info. You can see my profile before awarding me your project. https://www.freelancer.com/u/yadavexpert53 Thanks and R Daha Fazla

$2 USD / saat tutarından itibaren
(27 Değerlendirme)
4.2
IMBASANTAKUMAR

Dear Sir/Madam, After going through this project I found it matches my skills. Since it is among my major fields of expertise and also my preferred area that I always cover comprehensively to meet client expectations Daha Fazla

$2 USD / saat tutarından itibaren
(10 Değerlendirme)
2.4
Techbhakti

I m agree to do the work as $1 per solution I can do every possibility in Excel and VBA, Google Sheets and Google App scripts. I have 8+ year experience in Excel, VBA, Google Sheets and Google App Script... Plz share Daha Fazla

$2 USD / saat tutarından itibaren
(3 Değerlendirme)
2.2
ferdousjannat986

Hi, I just gone through your project and I'd like to say that I am interested for this project. I am new in this filed but I have worked as a administrator and there we worked on different projects with help of excel, Daha Fazla

$3 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
JuanCarlos593EC

You have to use the command "&" to concatenate formulas and that is. Put formula to return the day and concatenate with now

$3 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
humayoonkhan1212

I'll do this project for you As soon as possible if you give me a chance. The price is negotiable. You can send me an email at humayoonkhan 1212 at gmail i'll be waiting for your response. Thanks.

$3 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
lakhan2016

Hi sir , I can do this function onEdit() { var s = [login to view URL](); if( [login to view URL]() == "Sheet1" ) { //checks that we're on the correct sheet var r = [login to view URL](); if( [login to view URL]() == 1 ) { // Daha Fazla

$5 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
Xulianasatah

Hi, I have experience using google spreadsheet and I would like to help you to solve your problem. Hope you will give the opportunity to work with you. Thank you. Kind Regards, Xuliana Satah.

$3 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0