[belajar-access] menghitung selisih wakutu

 

Dear all,,

Mohon bantuan para Senior,

 

 

lagi iseng2 utak atik mencari selisih waktu

starttime: 05:1

endtime: 05:55

harusnya selisih menunjukan: 0:45

 

dengan Query ,

rumus1;   Duration: [endtime] - [starttime]

hasilnya: 12:45

 

rumus2; timediff: ([starttime],[endtime])

hasilnya: 12:45 (juga)

 

kalo start time: 05:10

Endtime: 06:55

maka Hasilnya: 1:45 (perhitungan Benar)

 

Gimana caranya supaya perhitungan dibawah 1 jam benar ??

Rumusnya apa yach

 

 

 

 

 

Regards

Harry Siswanto

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

SPAM IS PROHIBITED

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

A bad score is 579. A good idea is checking yours at freecreditscore.com.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___