Note: The other languages of the website are Google-translated. Back to English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 01 September 2022
  1 Replies
  2.1K Visits
0
Votes
Undo
Merhaba;

elimde 1,23093838 gibi bir veri var bu veriyi 1 gün 0,23 e karşılık gelen saat şekline çevirmek istiyorum.
5 months ago
·
#3050
0
Votes
Undo
Hi there,

Please try the formula below: =LEFT(A1,LEN(A1)-8)&" gün 0."&LEFT(RIGHT(A1,8),2)

Note that in this formula, A1 the cell that contains the number like 1,23093838, you should change that to your actual cell reference.

Amanda
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL