Menghitung Hari Orang Kerja

November 5, 2008 at 3:37 pm 1 comment

Menjawab pertanyaan Alali dalam shoutbox,

Berikut saya coba memakai rumus yang panjang sekali. Syarat data harus mirip dengan yang digunakan oleh Alali yaitu

2 orang x 2 hari x Rp. 1.210,-

setelah  1.210 ,- ada spasinya jadi kalau dihitung jumlah hurufnya adalah 8 char.

rumusnya :

=VALUE(LEFT(A2,FIND(” orang”,A2)-1))*

VALUE(MID(A2,FIND(“x”,A2)+2,FIND(“hari”,A2)-FIND(“x”,A2)-3))*

VALUE(SUBSTITUTE(MID(A2,FIND(“Rp.”,A2)+3,LEN(A2)-FIND(“Rp.”,A2)-5),”.”,””))

file excel dapat didownload rumus-untuk-menghitung-hok

Entry filed under: Ms Excel, Tips. Tags: , , , , .

Keputusan Jumlah Investasi dengan fungsi PV Excel Quick Entry – Entri Cepat -Keyboard

1 Comment Add your own

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 14 other followers

Blog Stats

  • 94,642 hits

Twitter Updates

Iklan


%d bloggers like this: