How do I convert standard time to 30 min increments?
 

I have an excel file with the time of appts. Appts are scheduled at 5 min
intervals starting at 7am and ending at 4:30pm. (i.e. 7:00, 7:05, 7:10 etc.)
I need to report the number of appts in 30 min spans. In other words I need
to know how many appts had a time between 7:00 and 7:25; how many between
7:30 and 7:55; how many between 8:00 and 8:25 and so on. Is there an easy way
to do this? Thanks!

How do I convert standard time to 30 min increments?
 

Please cancel my post. I found it =INT(A1*48). I promise I really had looked
before I posted but had not used the correct keywords. Thanks.

"Marty" wrote:

I have an excel file with the time of appts. Appts are scheduled at 5 min
intervals starting at 7am and ending at 4:30pm. (i.e. 7:00, 7:05, 7:10 etc.)
I need to report the number of appts in 30 min spans. In other words I need
to know how many appts had a time between 7:00 and 7:25; how many between
7:30 and 7:55; how many between 8:00 and 8:25 and so on. Is there an easy way
to do this? Thanks!

How do I convert standard time to 30 min increments?
 

Hi,

Because of the lack of information this will require a lot of guesswork.

Assumption 1. Your data are laid out something like this

Col A Col B
07:00
07:05 Mr Simth
07:10
07:15 Mr Jones
07:20
07:25 AN Other
07:30
07:35
07:40
07:45
07:50
07:55
08:00
08:05

If the times started in a1 then with 5 minute increments 16:30 would be in
A115

Assumption 2. When an appointment is taken something (a name?) is entered in
column B

To count the 07:00 - 07:25 appointments try this

SUMPRODUCT((A1:A115=TIME(7,0,0))*(A1:A115<=TIME(7 ,25,0))*(B1:B115<""))

Mike



"Marty" wrote:

I have an excel file with the time of appts. Appts are scheduled at 5 min
intervals starting at 7am and ending at 4:30pm. (i.e. 7:00, 7:05, 7:10 etc.)
I need to report the number of appts in 30 min spans. In other words I need
to know how many appts had a time between 7:00 and 7:25; how many between
7:30 and 7:55; how many between 8:00 and 8:25 and so on. Is there an easy way
to do this? Thanks!

How do I convert standard time to 30 min increments?
 

Well, thanks for posting back, 'cause I didn't know that ;O)

"Marty" wrote:

Please cancel my post. I found it =INT(A1*48). I promise I really had looked
before I posted but had not used the correct keywords. Thanks.

"Marty" wrote:

I have an excel file with the time of appts. Appts are scheduled at 5 min
intervals starting at 7am and ending at 4:30pm. (i.e. 7:00, 7:05, 7:10 etc.)
I need to report the number of appts in 30 min spans. In other words I need
to know how many appts had a time between 7:00 and 7:25; how many between
7:30 and 7:55; how many between 8:00 and 8:25 and so on. Is there an easy way
to do this? Thanks!