pake query juga bisa: SELECT Sum(Int(Left(Format([Jam],"HH:nn"),2)))+(Sum(Int(Right(Format([Jam],"HH:nn"),2)))\60) AS dtHours, Sum(Int(Right(Format([Jam],"HH:nn"),2))) Mod 60 AS dtMinutes FROM Table1;
Asumsi: tabel1.Jam format HH:nn Salam Hangat dan Jabat Erat, Edy WIYONO ----- Original Message ----- From: budhi prasetyo To: [email protected] Sent: Friday, December 19, 2008 10:47 Subject: [belajar-access] Sum of Time Dear Pakar Access Tanya dong untuk Sum of Time atau menjumlahkan Jam: hari 1: 10:12 hari 2: 8:30 hari 3: 8:10 --------------- + Total : 26:52 (26 jam 52 menit) Cara hitungnya pakai apa? supaya tampilnya 26:52 Thx Salam, \\budhi
