format jumlah jam menjadi angka/ number

[Jaka Ari]

bagaimana ya cara mengubah jumlah format jam menjadi angka:

contoh jumlah jam 279:00:00 ----> diubah menjadi 279 (279 format angka atau general)

.

terima kasih atas bantuanya 

[zainul ulum]

[Format jam]*24

Kemudian ubah format number ke genral

 

Sent from Mail for Windows

--
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 milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/2ebe89f8-58b6-426d-92b3-71687164ec1dn%40googlegroups.com.

 

[zainul ulum]

[ F o r m a t j a m ] * 2 4
K e m u d i a n u b a h f o r m a t n u m b e r k e g e n r a l

S e n t f r o m M a i l f o r W i n d o w s

F r o m : J a k a A r i
S e n t : W e d n e s d a y , N o v e m b e r 2 , 2 0 2 2 8
: 2 5 A M
T o : m i l i s B e l a j a r - E x c e l
S u b j e c t : [ m i l i s - b e l a j a r - e x c e l ] f o r m
a t j u m l a h j a m m e n j a d i a n g k a / n u m b e r

b a g a i m a n a y a c a r a m e n g u b a h j u m l a h f
o r m a t j a m m e n j a d i a n g k a :
c o n t o h j u m l a h j a m 2 7 9 : 0 0 : 0 0 - - - - > d
i u b a h m e n j a d i 2 7 9 ( 2 7 9 f o r m a t a n g k a
a t a u g e n e r a l )
.
t e r i m a k a s i h a t a s b a n t u a n y a
- -
Y o u r e c e i v e d t h i s m e s s a g e b e c a u s e y
o u a r e s u b s c r i b e d t o t h e G o o g l e G r o
u p s " m i l i s B e l a j a r - E x c e l " g r o u p .
T o u n s u b s c r i b e f r o m t h i s g r o u p a n d
s t o p r e c e i v i n g e m a i l s f r o m i t , s e n d
a n e m a i l t o m i l i s - b e l a j a r - e x c e l + u n s
u b s c r i b e @ g o o g l e g r o u p s . c o m .
T o v i e w t h i s d i s c u s s i o n o n t h e w e b
v i s i t h t t p s : / / g r o u p s . g o o g l e . c o m / d / m
s g i d / m i l i s - b e l a j a r - e x c e l / 2 e b e 8 9 f 8 - 5
8 b 6 - 4 2 6 d - 9 2 b 3 - 7 1 6 8 7 1 6 4 e c 1 d n % 4 0 g o o g l
e g r o u p s . c o m .