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

$2-3 USD / hour

Fermé

Publié

il y a plus de 3 ans

$2-3 USD / hour

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.

N° de projet : 29067085

Concernant le projet

9 propositions

Projet à distance

Actif à il y a 3 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

9 freelances proposent en moyenne $3 USD/heure pour ce travail

@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 complete your project with the highest quality and accuracy. I am ready to show you free sample. Please contact me for more clarity. Waiting for your quick reply. Thank you!! Rabeya.

$3 USD en 40 jours

5,0

(13 commentaires)

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 Regards, Mohit

$2 USD en 40 jours

4,9

(27 commentaires)

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 and give outstanding results, I hereby request we proceed to a chat so we discuss it in detail. I will work on the instructions that you will provide and finish this task for you. Please consider my bid.

$2 USD en 40 jours

5,0

(10 commentaires)

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 your requirements, I will surely help you on the same... I am bidding Lowest. As I am new at freelancer, looking for good ratings and reviews, So you will not be disappointed at all..

$2 USD en 48 jours

5,0

(3 commentaires)

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, .word, Excel Macro. I can provide accuracy within a deadline.

$3 USD en 40 jours

0,0

(0 commentaires)

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 en 40 jours

0,0

(0 commentaires)

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 en 40 jours

0,0

(0 commentaires)

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 en 40 jours