Time formatting

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Hello Does anyone know how to format grouping your data in
reports in half hour and 15 minute increments?
 
Since one day is the equivalent of "1" then one hour is 1/24 and a half hour
is 1/48. Therefore, you can set the sorting and grouping dialog to something
like:
=Int([DateTimeField] * 48)
or
=Int([DateTimeField] * 96)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repost Reporting Time intervals 4
Calculate Time in A Report 5
Industrial Time look up sheet 1
Increment value for sorting 7
sequentally numbering records in a report 2
Cannot get graph to work properly 1
Do...Loop Help 6
add/sub time/hour tracking in 24 clock format 1

Back
Top