Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 01 September 2022
  1 Replies
  1.5K 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.
2 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.