Access Time Calculations 1

[CCS8DENI]

I have been throwing this around with little luck.<br><br>Is it possible to either insert an expression or format an unbound field at the foot of a report that can add up a set of times and give a number larger than 24.<br><br>ie the following times appear in the detail area, 3:30&nbsp;&nbsp;&nbsp;16:40&nbsp;&nbsp;&nbsp;12:00&nbsp;&nbsp;&nbsp;<br>The return I get is 8:10 instead of 32:10<br><br>Cheers <p>Andrew<br><a href=mailto:andrew.mcmillan@det.nsw.edu.au>andrew.mcmillan@det.nsw.edu.au</a><br><a href= > </a><br>Technology Adviser<br>
Dept. of Education and Training<br>
Deniliquin District<br>
New South Wales<br>
Australia

 

[elizabeth]

I think I saw that you cross-posted this in an Access forum. Did the DatePat function work for you? If not, maybe you need to do your math with numerics (I'm guessing you're using a date format for the results).

 

[BobCrawf]

Try using the time format h:mm. If you use the default or hh:mm, it will roll-over at 24 HRS.