Repost Reporting Time intervals

I am trying to run a report that shows time intervals of
1/2 hour and 15 minute increments right now on the report
the time field looks like this:
=Format$([Time],"h ampm",0,0)
Currently the report breaks the time in hour increments.
Thanks in advance!!

Did you try the solution that I suggested in my reply yesterday? If so, did
it work? If it didn't work, please provide more information.

--
Duane Hookom
MS Access MVP
--

"Jay" wrote in message
...
I am trying to run a report that shows time intervals of
1/2 hour and 15 minute increments right now on the report
the time field looks like this:
=Format$([Time],"h ampm",0,0)
Currently the report breaks the time in hour increments.
Thanks in advance!!

Yes I did try the formula you gave however it only showed
as 12:00 AM on the report.
-----Original Message-----
Did you try the solution that I suggested in my reply
yesterday? If so, did
it work? If it didn't work, please provide more
information.

--
Duane Hookom
MS Access MVP
--

"Jay" wrote in
message
...
I am trying to run a report that shows time intervals of
1/2 hour and 15 minute increments right now on the
report
the time field looks like this:
=Format$([Time],"h ampm",0,0)
Currently the report breaks the time in hour increments.
Thanks in advance!!


.

Try this formula.
Val(Hour([Time]))+(Int((Minute([Time])+14)/15)/4)
You may want to adjust the 14 and 15 above to adjust for
the rounding you wish to employ.
By the way "Time" is an Access function name, I would
recommend to give this variable some other name.
Hope this helps
-----Original Message-----
I am trying to run a report that shows time intervals of
1/2 hour and 15 minute increments right now on the report
the time field looks like this:
=Format$([Time],"h ampm",0,0)
Currently the report breaks the time in hour increments.
Thanks in advance!!
.

Setting up your sorting and grouping will not show you anything on the
report. It will only set your sorting and grouping.

--
Duane Hookom
MS Access MVP


"Jay" wrote in message
...
Yes I did try the formula you gave however it only showed
as 12:00 AM on the report.
-----Original Message-----
Did you try the solution that I suggested in my reply
yesterday? If so, did
it work? If it didn't work, please provide more
information.

--
Duane Hookom
MS Access MVP
--

"Jay" wrote in
message
...
I am trying to run a report that shows time intervals of
1/2 hour and 15 minute increments right now on the
report
the time field looks like this:
=Format$([Time],"h ampm",0,0)
Currently the report breaks the time in hour increments.
Thanks in advance!!


.