[milis-belajar-excel] Formula Selisih Jam

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Formula Selisih Jam

harbud
Selamat Malam Guru Semua

Mohon pencerahannya mengenai formula selisih Jam dan Jika Jam Tsb Beda hari

File terlampir

Terima kasih sebelumnya
Salam

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGHNbDNNCThLxDdiJm80ERaDWesxP-RSL-%3DMQ2B9s7xCWO3wGg%40mail.gmail.com.

Formula Selisih Jam.xlsx (15K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Formula Selisih Jam

harbud
Selamat Malam Guru Semua

Mohon pencerahannya mengenai formula selisih Jam dan Jika Jam Tsb Beda hari

File terlampir

Terima kasih sebelumnya
Salam

Formula Selisih Jam.xlsx (15K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Formula Selisih Jam

Jatmiko
Dear Pak Harry,

Coba dicek lampiran berikut Pak,
Apakah sudah sesuai yang diinginkan?

BR,


On Thu, Nov 19, 2020 at 8:12 AM harry budiman [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
>
> Selamat Malam Guru Semua
>
> Mohon pencerahannya mengenai formula selisih Jam dan Jika Jam Tsb Beda hari
>
> File terlampir
>
> Terima kasih sebelumnya
> Salam
>
>
>

Re-Formula Selisih Jam.xlsx (15K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Formula Selisih Jam

odong nando
In reply to this post by harbud
hai harry

saya bukan guru apalagi master,

cuma sebelum para guru dan master turun tangan mungkin file terlampir bisa jadi bahan dari pada ga ad...

hehehe...

On Tue, Nov 17, 2020 at 9:42 PM harry budiman <[hidden email]> wrote:
Selamat Malam Guru Semua

Mohon pencerahannya mengenai formula selisih Jam dan Jika Jam Tsb Beda hari

File terlampir

Terima kasih sebelumnya
Salam

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGHNbDNNCThLxDdiJm80ERaDWesxP-RSL-%3DMQ2B9s7xCWO3wGg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGZ5tN45iYdr4BM18ZfHNpBAQ_qyXY6p4Lu6JYynYJ2rgOW1Dg%40mail.gmail.com.

Formula Jam_OD.xlsx (16K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Formula Selisih Jam

Agus-2
In reply to this post by harbud
Hallo Mas Budiman.
Kebetulan saya seorang guru anak-anak kecil, tetapi bukan guru excel lho!
saya juga pemula dalam excel.

Menurut penjelasan mas Kid waktu webinar kemarin, lakukan langkah-langkah:
1. ketik formula di I8: =F8-D8
2. Format cell I8 dengan cara klik format cell, pada tab: Number bagian Category: klik Custom, kemudian ketik di Type: 0 "hari"
(jadi di dalam cell masih tetap angka yang masih dapat dihitung kembali. seedangkan milik anda sudah tidak dapat dihitung. coba di cell lainnya ketik rumus =I8 + 3 )pasti error.
3. di cell J8 ketik formula =F8+G8-D8-E8
4. Format cell J8 dengan cara klik format cell, pada tab: Number bagian Category: klik Custom, kemudian ketik di Type: h "jam" mm "menit"
(jadi di dalam cell masih tetap angka yang masih dapat dihitung kembali. sedangkan milik anda sudah tidak dapat dihitung. coba di cell lainnya ketik rumus =J8 + 3/24 pasti error, sedangkan dengan rumus diatas pasti tidak error.

On 11/17/2020 7:33 PM, harry budiman wrote:
Selamat Malam Guru Semua

Mohon pencerahannya mengenai formula selisih Jam dan Jika Jam Tsb Beda hari

File terlampir

Terima kasih sebelumnya
Salam

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGHNbDNNCThLxDdiJm80ERaDWesxP-RSL-%3DMQ2B9s7xCWO3wGg%40mail.gmail.com.


--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1e959650-8c0a-2749-279e-857f1c93bee6%40gmail.com.