using start time and end time to calculate durations by hour

  • Thread starter tthomas via AccessMonster.com
  • Start date
T

tthomas via AccessMonster.com

Greetings,
I have a table that contains events that have a start date/time and end
date/time. I would like to calculate durations broken out by hour.
So
12:00:00 - 12:59:59 am - summed number of minutes that occured during that
time range
01:00:00 - 01:59:59 am - summed number of minutes that occured during that
time range
etc..

I have some ideas on how to brute force through this, but knowing the amazing
minds out here, figure that someone has figured out an elegant solution...
Thanks,
Teresa
 

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

Determine if night shift by start & end time 2
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? 0
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? 0
separating date and time 5
Averaging by half hour time intervals. 0
Query to count time range 4
date based query fails to find records in given period 9
Calculate end date and time 1

Top