Error adding hours

[mtagliaferri]

I have the following SQL to add hours

SELECT tblTrip.PaySlipReference, Sum(tblTrip.NDays) AS TotNDays, Int(Sum(tblTrip.FlyingTime)*24)&"."& Format (Sum(tblTrip.FlyingTime),"nn") AS TotFlyingTime, Int(Sum(tblTrip.DutyTime))&"."& Format(Sum(tblTrip.FlyingTime),"nn") AS TotDutyTime, Int(Sum(tblTrip.TAFB))&"."& Format(Sum(tblTrip.TAFB),"nn") AS TotTAFB, Sum(tblTrip!DutyPayRate*tblTrip!TAFB) AS TotDutyPay, Count(tblTrip.NDays) AS NumberOfTrips
FROM tblTrip
GROUP BY tblTrip.PaySlipReference;

Refering to the part "AS TotFlyingTime" it works perfectly as the format is a 24h and never goes over 23.59 hh.mm. The problem I incour is a incorrect result for the other two parts of the code: "AS TotDutyTime" and "ASTotTAFB", these data have values over 23h59m.

 

[RuralGuy]

Maybe this link will help. Time, adding and subtracting time and timesheets

 

[EMP]

SELECT tblTrip.PaySlipReference, Sum(tblTrip.NDays) AS TotNDays,

Int(Sum(tblTrip.FlyingTime)*24)&"."& Format (Sum(tblTrip.FlyingTime),"nn") AS TotFlyingTime,

Int(Sum(tblTrip.DutyTime))&"."& Format(Sum(tblTrip.FlyingTime),"nn") AS TotDutyTime,

Int(Sum(tblTrip.TAFB))&"."& Format(Sum(tblTrip.TAFB),"nn") AS TotTAFB,

Sum(tblTrip!DutyPayRate*tblTrip!TAFB) AS TotDutyPay, Count(tblTrip.NDays) AS NumberOfTrips
FROM tblTrip
GROUP BY tblTrip.PaySlipReference;


The three expressions are inconsistent. They are not in the same structure.

^