I have dates in a column and the amount of time in a room in another column can some one tell me how to get this into a graph. vertical axis will be the median time in the room and the horizontal axis will be the day of the week,(monday, tuesday etc).
Last edited by texknight; 06-11-2009 at 05:19 PM.
Welcome to the forum.
=text(a1, "dddd")
Entia non sunt multiplicanda sine necessitate
I already have the dates converted to day of the week in that column just by using the format cell. Now I'd like to figure out how to calculate each row that has Monday tues, wed etc, and give me the Median time of each day of the week that is in a different column.
Thanks for the welcome!
Post an example and explain in context.
PROCdat ROOMTIME
Tuesday 0:59
Tuesday 0:55
Saturday 1:14
Friday 0:43
Wednesd 0:26
Thursday 2:58
Sunday 0:57
Monday 1:41
Friday 1:00
Sunday 0:34
Wednesd 0:50
Thursday 0:52
Monday 1:29
Wednesd 0:52
Friday 2:07
Friday 1:01
Friday 1:12
Sunday 1:29
Thursday 0:42
So now
Day of week Median time
Monday XX:XX
Tuesday XX:XX
Wednesday XX:XX
Etc....
Does that help?
Thanks again.
Umm -- how about an example workbook
Ah ha didn't see that at the bottom... here ya go.
The array formula in F2 and copied down is =MEDIAN(IF(WEEKDAY($A$2:$A$20)=D2, $B$2:$B$20))
Please Login or Register to view this content.
It MUST be confirmed with Ctrl+Shift+Enter, not Enter
This has been frustrating me for at least a week. That is exactly what I wanted it to look like. Thanks for helping out!
You're welcome. Would you please mark the thread as Solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks