Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timekeeping Question
I have about 65 worksheets in a workbook that record an employees
time/activities. A particular code is given per activity per line. Times are calculated automatically and codes are given by a Vlookup depending on information that is unrelatd to this question. A sheet might read for example: 8:30-9:30 60 min P 9:30-9:50 20 min S 9:50-11:00 70 min C etc. My question is I would like to know the ratio of activity on particular codes throughout the day in increments of 5 or 10 minutes. So I would like to see at 9:30-9:40 how many were on P, S, C, etc. Then from 9:40-9:50 etc. I realize I would need to dedicate a new page in my workbook to dump all the info from each individual sheet. I am just not sure how to extract data in small increments when the original times recorded are in larger lumps of time. I hope this makes sense. Any help is appreciated! -CRM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timekeeping Question
Is the data really in the format 8:30-9:30 ? That means it is in text format
and this adds to the problem. I hope 8:30 is in column A and 9:30 in column B. Tell us please best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "blueriver" wrote in message ... I have about 65 worksheets in a workbook that record an employees time/activities. A particular code is given per activity per line. Times are calculated automatically and codes are given by a Vlookup depending on information that is unrelatd to this question. A sheet might read for example: 8:30-9:30 60 min P 9:30-9:50 20 min S 9:50-11:00 70 min C etc. My question is I would like to know the ratio of activity on particular codes throughout the day in increments of 5 or 10 minutes. So I would like to see at 9:30-9:40 how many were on P, S, C, etc. Then from 9:40-9:50 etc. I realize I would need to dedicate a new page in my workbook to dump all the info from each individual sheet. I am just not sure how to extract data in small increments when the original times recorded are in larger lumps of time. I hope this makes sense. Any help is appreciated! -CRM |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timekeeping Question
Bernard,
Thanks for the speedy reply. The data in the cell is recorded as 8:30:00 AM in column A and 9:30:00 AM in column B, and then progressing the same down the worksheet. When I print the sheet it only displays 8:30 AM, 9:30 AM, etc into the PM's. Thanks! -crm "Bernard Liengme" wrote: Is the data really in the format 8:30-9:30 ? That means it is in text format and this adds to the problem. I hope 8:30 is in column A and 9:30 in column B. Tell us please best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "blueriver" wrote in message ... I have about 65 worksheets in a workbook that record an employees time/activities. A particular code is given per activity per line. Times are calculated automatically and codes are given by a Vlookup depending on information that is unrelatd to this question. A sheet might read for example: 8:30-9:30 60 min P 9:30-9:50 20 min S 9:50-11:00 70 min C etc. My question is I would like to know the ratio of activity on particular codes throughout the day in increments of 5 or 10 minutes. So I would like to see at 9:30-9:40 how many were on P, S, C, etc. Then from 9:40-9:50 etc. I realize I would need to dedicate a new page in my workbook to dump all the info from each individual sheet. I am just not sure how to extract data in small increments when the original times recorded are in larger lumps of time. I hope this makes sense. Any help is appreciated! -CRM |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timekeeping Question
Will try to get you a solution tomorrow
Want to send me private email ? Just remove TRUENORTH. from address -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "blueriver" wrote in message ... Bernard, Thanks for the speedy reply. The data in the cell is recorded as 8:30:00 AM in column A and 9:30:00 AM in column B, and then progressing the same down the worksheet. When I print the sheet it only displays 8:30 AM, 9:30 AM, etc into the PM's. Thanks! -crm "Bernard Liengme" wrote: Is the data really in the format 8:30-9:30 ? That means it is in text format and this adds to the problem. I hope 8:30 is in column A and 9:30 in column B. Tell us please best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "blueriver" wrote in message ... I have about 65 worksheets in a workbook that record an employees time/activities. A particular code is given per activity per line. Times are calculated automatically and codes are given by a Vlookup depending on information that is unrelatd to this question. A sheet might read for example: 8:30-9:30 60 min P 9:30-9:50 20 min S 9:50-11:00 70 min C etc. My question is I would like to know the ratio of activity on particular codes throughout the day in increments of 5 or 10 minutes. So I would like to see at 9:30-9:40 how many were on P, S, C, etc. Then from 9:40-9:50 etc. I realize I would need to dedicate a new page in my workbook to dump all the info from each individual sheet. I am just not sure how to extract data in small increments when the original times recorded are in larger lumps of time. I hope this makes sense. Any help is appreciated! -CRM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Can't see my question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
please help with timekeeping in excel | Excel Worksheet Functions |