Tamamlanmış

Convert Date Format from "2d 1h 2m" to "11.01 h" in Google Spreadsheet

Hi,

I have a date in a columnt which is in the following format:

- 3d 1h 30m

1d = 8 hours so in hours you will have a time estimation of 25.5h

Now 3d 1h 30m should be converted in a new cell to 25.5hh

I need a google script or a formula to do so.

Beceriler: Excel, Javascript

Daha fazlasını gör: google spreadsheet xml flash, google spreadsheet php, import data wordpress google spreadsheet, sync excel google spreadsheet, download google search results csv format, google spreadsheet finance tse, mlsca google spreadsheet, manuale per google spreadsheet, google stock market data format, commands google spreadsheet finance, google spreadsheet access table, use google spreadsheet access table, php form google spreadsheet, google finance google spreadsheet, google spreadsheet data entry, google spreadsheet functions manual, php mysql data google spreadsheet

İşveren Hakkında:
( 37 değerlendirme ) Hamburg, Germany

Proje NO: #14807116

Seçilen:

alexanderrubtsov

Hello. I propose to write Google sheet formulas for the conversion. Bes regards, Alexander.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(11 Değerlendirme)
4.2

Bu iş için 34 freelancer ortalamada €20 teklif veriyor

cgullapalli

Hi, I am good at Google formulas. I understood the requirements. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra

in %bids___i_period_sub_35% gün içinde13%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(589 Değerlendirme)
7.6
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(203 Değerlendirme)
6.8
BaNgan

Hi, If you accept this script result then I can create a formula on your spreadsheet [login to view URL] Feel free to contact me via Skype: bangank36, my timezone is GMT+7. My resume website: http:// Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(186 Değerlendirme)
6.8
ksriniravi

Greetings! Assuming the value is in cell F6, formula is 8*MID(F6,FIND("d",F6)-1,1)+MID(F6,FIND("h",F6)-1,1)+(MID(F6,FIND("m",F6)-2,2)/60). Please try it out and if satisfied, award the project. Have a Great W Daha Fazla

in %bids___i_period_sub_35% gün içinde8%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(115 Değerlendirme)
6.3
sisicirnes

Hello! My name is Irnes and I'm a data entry/web search specialist from Bosnia and Herzegovina. I'm here to prove my skills and quality of the work. The Freelancer website gave me a preferred status. More than 95% Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(27 Değerlendirme)
6.2
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy

in %bids___i_period_sub_35% gün içinde13%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(214 Değerlendirme)
6.2
hatemfreelance4

“Budget and project period are flexible to meet to your requirement” I’m an Electrical Engineer. I am very interested in Web search and data input task and also i have a good experience in this field. I am responsib Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(67 Değerlendirme)
5.6
MoohHHooM

Hi, i can help you with this project, please let me know more about it :) .

in %bids___i_period_sub_35% gün içinde14%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)
5.3
tanjirdramatist

Dear Sir, I have read your job description & have understood your all requirement. I have also a big team to complete it earlier. After seeing my previous record, You will decide that I will be the Right person Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(102 Değerlendirme)
5.4
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. I can do it also in google spreadsheet and your project in short time. Feel free to message me to start the job. Thank you so much.

in %bids___i_period_sub_35% gün içinde24%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(61 Değerlendirme)
5.2
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(40 Değerlendirme)
5.6
celalaybar

I can convert date format in Google Spreadsheet. I pay more attention to details in my work. I am good at JavaScript, Google Spreadsheet and Google Script. I have done with similar jobs before. I hope both Daha Fazla

in %bids___i_period_sub_35% gün içinde11%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(29 Değerlendirme)
5.0
Nidhijain123

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in ge Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(59 Değerlendirme)
5.5
mohamedkaram93

Hi there! I will be happy to help you with that simple one. We can define both custom formula and script, the custom formula will be helpful if you are trying to edit few cells, but it will generate errors if you ar Daha Fazla

in %bids___i_period_sub_35% gün içinde24%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
4.2
dvcontact

Hi, If you are looking for a professional and reliable Data Entry expert with proficiency in online research and web scraping, I'm your ideal candidate. I'm highly experienced in data mining and I have a strong back Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(13 Değerlendirme)
4.4
muddassir12

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(13 Değerlendirme)
3.9
avijitdey239

hi sir how are [login to view URL] i saw your job offer and we are interested to do your [login to view URL] you give us this job we will be very happy to do your [login to view URL] you have nice day...

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(5 Değerlendirme)
3.5
anzarulislam

Hi.. I am interested to your project . I believe that I'll do this work properly and in timely . I am agree with your budget. And I'm sure that I'll finish the task with your full satisfaction . Lets start Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(7 Değerlendirme)
3.7
dayakmlt

Split the date to 3 column, assign 8hrs to data, and then add all three column

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(13 Değerlendirme)
3.4
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(11 Değerlendirme)
2.8