//honeypot demagogic

 Forum DhammaCitta. Forum Diskusi Buddhis Indonesia

« previous next »
Pages: [1]   Go Down

Author Topic: Help Rumus Excel!  (Read 3977 times)

0 Members and 1 Guest are viewing this topic.

Offline M14ka

  • KalyanaMitta
  • *****
  • Posts: 4.821
  • Reputasi: 94
  • Gender: Female
  • Live your best life!! ^^
Help Rumus Excel!
« on: 19 July 2011, 02:34:35 PM »
Temen2 bantuin donk....
Gmn ya cara untuk convert mis 0:30 menit jadi 0.5 jam
Trus rumus  02:10-21:00 kok munculnya ################# ya? Hrusnya 5:10
Format time kok mesti pake am n pm y isinya ad yg lebih mudah gak? Thx.... >.<
« Last Edit: 19 July 2011, 02:39:52 PM by M14ka »
Logged

Offline No Pain No Gain

  • Sebelumnya: Doggie
  • KalyanaMitta
  • *****
  • Posts: 2.796
  • Reputasi: 73
  • Gender: Male
  • ..............????
Re: Help Rumus Excel!
« Reply #1 on: 19 July 2011, 02:59:47 PM »
Quote from: M14ka on 19 July 2011, 02:34:35 PM
Temen2 bantuin donk....
Gmn ya cara untuk convert mis 0:30 menit jadi 0.5 jam
Trus rumus  02:10-21:00 kok munculnya ################# ya? Hrusnya 5:10
Format time kok mesti pake am n pm y isinya ad yg lebih mudah gak? Thx.... >.<


coba pake rumus ini:
ROUND(A1*24,0)
Logged
No matter how dirty my past is,my future is still spotless

Offline kakao

  • KalyanaMitta
  • *****
  • Posts: 1.197
  • Reputasi: 15
  • Gender: Male
  • life is never sure, but die is certain
Re: Help Rumus Excel!
« Reply #2 on: 19 July 2011, 03:00:57 PM »
aaaaaaa......excel,.sorry cute nggak bisa bantu,..kakao udah lupa ma program office,.soalnya jarang digunakan  ^:)^ maaf ya cute ^:)^
Logged
"jika kau senang hati pegang jari, jika kau senang hati pegang jari dan masukan kehidungmu !!"
[img]http://upload.wikimedia.org/wikipedia/id/c/c3/Sailor_moon_ani.gif[img]

Offline M14ka

  • KalyanaMitta
  • *****
  • Posts: 4.821
  • Reputasi: 94
  • Gender: Female
  • Live your best life!! ^^
Re: Help Rumus Excel!
« Reply #3 on: 19 July 2011, 03:06:52 PM »
Quote from: No Pain No Gain on 19 July 2011, 02:59:47 PM
coba pake rumus ini:
ROUND(A1*24,0)
ini untuk yg mana kk? trh dimana rumusnya?
Logged

Offline M14ka

  • KalyanaMitta
  • *****
  • Posts: 4.821
  • Reputasi: 94
  • Gender: Female
  • Live your best life!! ^^
Re: Help Rumus Excel!
« Reply #4 on: 19 July 2011, 03:13:24 PM »
Quote from: No Pain No Gain on 19 July 2011, 02:59:47 PM
coba pake rumus ini:
ROUND(A1*24,0)

Quote from: M14ka on 19 July 2011, 03:06:52 PM
ini untuk yg mana kk? trh dimana rumusnya?

Wow... uda bs....kerennn... Thx kk.....^__________^
Logged

Offline aitristina

  • KalyanaMitta
  • *****
  • Posts: 2.758
  • Reputasi: 52
  • Gender: Female
  • every1 is #1...
Re: Help Rumus Excel!
« Reply #5 on: 27 August 2011, 09:10:33 PM »
round fungsi utk apa ya?

Quote from: No Pain No Gain on 19 July 2011, 02:59:47 PM
coba pake rumus ini:
ROUND(A1*24,0)
Logged
Life is about living...

Offline evi.n

  • Bukan Tamu
  • *
  • Posts: 1
  • Reputasi: 1
  • Semoga semua mahluk berbahagia
Re: Help Rumus Excel!
« Reply #6 on: 27 August 2011, 09:51:33 PM »
Quote from: M14ka on 19 July 2011, 02:34:35 PM
Gmn ya cara untuk convert mis 0:30 menit jadi 0.5 jam -->> yang ini uda ya

Trus rumus  02:10-21:00 kok munculnya ################# ya? Hrusnya 5:10 -->> karena selisih waktu menunjukkan negatif, jadi hasilnya ###. kalo mau, dibalik rumusnya jadi 21:00-02:10

Format time kok mesti pake am n pm y isinya ad yg lebih mudah gak? -->> bisa dicoba langkah berikut:
  • blok cell waktu yang mw diganti tsb
  • klik kanan
  • pilih format cells
  • di tab "number": pilih "time"; di box "locate (location)": pilih indonesia
  • OK
[/color]

semoga bermanfaat....  _/\_

Logged

Offline M14ka

  • KalyanaMitta
  • *****
  • Posts: 4.821
  • Reputasi: 94
  • Gender: Female
  • Live your best life!! ^^
Re: Help Rumus Excel!
« Reply #7 on: 07 September 2011, 01:45:02 PM »
Logged
Pages: [1]   Go Up
« previous next »
 

anything