I have a few data files that are imported from another system (that I can't access/modify) into an Access application I put together. The files contain a few fields with data values in 'Short Time' format (ex: 0:45 or 8:30). I know there is no easy way of adding time values past 24 hours (or is there?). I'm forced into adding the values using something like: [FieldX] & ":" & if(([FieldX]-Int(FieldX])*60)<10,"0"&([FieldX]-Int([FieldX])*60,([FieldX]-Int(FieldX])*60)) where [FieldX] is the sum of time values. But what if the sum is > 24? I've read numerous posts on dealing with time values, but keep going back to my lengthy (almost incomprehensible) formulas (but they do work). I was thinking of converting the time values to general numbers, doing the math and then reconverting back to hh:mm. If so, what's the best way? Thanks for any help anyone can provide.