Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
Morning,
I have got records that have been recorded at different times. Now I want to group them from 06:00 - 09:00, 09:01 - 12:00, 12:01 - 15:00, 15:01 - 18:00 etc. So I should have 8 Groups that should make the recordings easier to show on a graph. The times are shown in column D. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
Add a helper columned with
=CHOOSE(INT(K1/TIME(3,0,0))+1,"00:00-03:00","03:01-06:00","06:01-09:00","09:01-12:00") I will leave you to add the other 4 groups -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sunnyskies" wrote in message ... Morning, I have got records that have been recorded at different times. Now I want to group them from 06:00 - 09:00, 09:01 - 12:00, 12:01 - 15:00, 15:01 - 18:00 etc. So I should have 8 Groups that should make the recordings easier to show on a graph. The times are shown in column D. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
4 groups are ok. time should be continuous. If an event occurs at 15:00:30
it is not in your range of times. Times should be 06:00 - 09:00, 09:00 - 12:00, 12:00 - 15:00, 15:00 - 18:00 "Sunnyskies" wrote: Morning, I have got records that have been recorded at different times. Now I want to group them from 06:00 - 09:00, 09:01 - 12:00, 12:01 - 15:00, 15:01 - 18:00 etc. So I should have 8 Groups that should make the recordings easier to show on a graph. The times are shown in column D. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
Thank you Bob, solved a massive problem.
Suggest you start your weekend early ..... how about from now. Cheers "Bob Phillips" wrote: Add a helper columned with =CHOOSE(INT(K1/TIME(3,0,0))+1,"00:00-03:00","03:01-06:00","06:01-09:00","09:01-12:00") I will leave you to add the other 4 groups -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sunnyskies" wrote in message ... Morning, I have got records that have been recorded at different times. Now I want to group them from 06:00 - 09:00, 09:01 - 12:00, 12:01 - 15:00, 15:01 - 18:00 etc. So I should have 8 Groups that should make the recordings easier to show on a graph. The times are shown in column D. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
Too much to do, I am off on a trip Saturday.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sunnyskies" wrote in message ... Thank you Bob, solved a massive problem. Suggest you start your weekend early ..... how about from now. Cheers "Bob Phillips" wrote: Add a helper columned with =CHOOSE(INT(K1/TIME(3,0,0))+1,"00:00-03:00","03:01-06:00","06:01-09:00","09:01-12:00") I will leave you to add the other 4 groups -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sunnyskies" wrote in message ... Morning, I have got records that have been recorded at different times. Now I want to group them from 06:00 - 09:00, 09:01 - 12:00, 12:01 - 15:00, 15:01 - 18:00 etc. So I should have 8 Groups that should make the recordings easier to show on a graph. The times are shown in column D. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TWO FILES OPEN AT SAME TIME XLS:1 AND XLS:2 GROUP??? | Excel Discussion (Misc queries) | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |