Sorting for Report by time

M

Montez659

Well-known Member
Joined
May 4, 2005
Messages
918
I have created a simple db to log my time each day. I run a report that can show what I did by category however, whenever I sort by the date field (which includes time) it doesn't recognize the hours and minutes aspect and only sort by the date and then by record number. Is there something quirky that I need to do to sort by the time in ascending order?
 
Sort by date Sort by votes

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
You must log in or register to reply here.

Similar threads

JenniferMurphy
  • Question Question
How to structure a variable product rating database
Replies
5
Views
945
mdmilner
M
T
  • Solved
Query to choose 5 records at random while excluding records based on criteria.
Replies
3
Views
475
Micron
M
G
  • Question Question
Sum of Time
Replies
6
Views
657
Micron
M
tjdrake
  • Solved
Multi-User Access DB Table
Replies
3
Views
1K
Micron
M
T
  • Question Question
Advice on exporting a table to a CSV
Replies
2
Views
1K
Micron
M

Forum statistics

Threads
1,225,071
Messages
6,182,685
Members
453,132
Latest member
nsnodgrass73

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top