Excel: kira duration between date and times

[muslimtrader]

Assalam,

mintak tolong forumer utk formula kan dlm excel utk kira number of days between dates and time....contoh,

start date: 01 Jan 2013
Start time: 0000

End date: 5 Jan 2013
End time: 1200

klau bleh setiap cell separate....

jawapan 4.5 days...

dh tanya pakcik google...tp tk jumpa...huhuhu(((

 

[muslimtrader]

tolongggg....

 

[zan_kola]

nak mcm nih ker??



Uploaded with ImageShack.us

 

[bangsi]

nak mcm nih ker??



Uploaded with ImageShack.us

betoi..... kawe dh acu cuba try & test dh!

 

[Hoyoyo]

rasa senang insert function DAYS360

 

[mutanic]

Try ni :

Value :

Cell A1 = 28/11/2013
Cell A2 = 05/12/2013

atau

Cell A1 = 28/11/2013
Cell B1 = 05/12/2013

Formula :

DAY :
=DAY(A2)-DAY(A1)
atau
=DAY(B1)-DAY(A1)

MONTH :
=MONTH(A2)-MONTH(A1)
atau
=MONTH(B1)-MONTH(A1)

YEAR :
=YEAR(A2)-YEAR(A1)
atau
=YEAR(B1)-YEAR(A1)

Kalu ikut soalan asal TT boleh refer kat sini :