format time greater than 24 hours

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

css - 08 Apr 2008 13:59 GMT

I have a running sum in my report that is formatted as a short time. Once the
sum becomes greater that 24:00, it resets to zero.

How can I display 25:37 in my report?

Thanks,
Connie

Reply to this Message

Allen Browne - 08 Apr 2008 15:02 GMT

Use DateDiff() to get the number of minutes.

Set up a text box in the report footer, with these properties:
Control Source =DateDiff("n", #0:00#, Sum([YourTimeFieldNameHere]))
Format General Number
Visible No
Name txtMinutes

Now place another text box in the same section, with Control Source:
=[txtMinutes] \ 60 & Format([txtMinutes] Mod 60, "\:00")

Explanation:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have a running sum in my report that is formatted as a short time.
> Once the sum becomes greater that 24:00, it resets to zero.
[quoted text clipped - 3 lines]
> Thanks,
> Connie

Reply to this Message

css - 08 Apr 2008 15:19 GMT

Thanks, Allen!!

> Use DateDiff() to get the number of minutes.
>
[quoted text clipped - 19 lines]
> > Thanks,
> > Connie

Reply to this Message