First post in this forum. I am an Excel novice. I can develop simple formulas. I did my first pivot table last week. The only VBA I've done is stuff I've copied from others and pasted into my own spreadsheet. Some of the questions I have I'm sure can be done, but am unfamiliar with terms needed to search for information on how to do it. For example, I know I've seen pivot tables in others' spreadsheets before, but had no idea what they were called before last week.
I need to track my project hours. I currently have a worksheet that I enter start time, stop time, and project name. The elapsed time is calculated from the start and stop times, and I have a pivot table to summarize the weekly hours by project. But, it is unwieldy. I would like to know if it's possible for an Excel novice, like myself, to do the following:
1) Currently, I enter the start and stop times as military time with a colon, i.e. 14:30 for 2:30 PM. I would like to forgo having to enter the colon and just enter the numbers 1430 and have Excel come up with 2:30 PM.
2) <strike>I would like to avoid having to enter the start time for a row, with the exception of the very beginning of the day. I don't want to use the previous row's stop time *unless* there is a non-blank value in the project name cell in the current row.</strike> I've figured this one out! In my D15 cell: =IF(C15<>"",C15,(IF(G15<>"",E14,""))) where C15 is from my "manual start" entry (for beginning of day), G15 is my project name cell, and E14 is the previous row's stop time.
3) I would like the project name cell to have a drop down to select from a list maintained in a separate worksheet. No entry would be allowed in the cell and could only contain the value selected from the project list.
4) Currently, I do not make entries for my lunch and other breaks, mainly because it would show up in my weekly hours summary. So, if I were to get #2, I would need a way to filter out those breaks from the weekly hours summary.
Doable for a novice? RTFMs / RTFLs are welcomed!
I need to track my project hours. I currently have a worksheet that I enter start time, stop time, and project name. The elapsed time is calculated from the start and stop times, and I have a pivot table to summarize the weekly hours by project. But, it is unwieldy. I would like to know if it's possible for an Excel novice, like myself, to do the following:
1) Currently, I enter the start and stop times as military time with a colon, i.e. 14:30 for 2:30 PM. I would like to forgo having to enter the colon and just enter the numbers 1430 and have Excel come up with 2:30 PM.
2) <strike>I would like to avoid having to enter the start time for a row, with the exception of the very beginning of the day. I don't want to use the previous row's stop time *unless* there is a non-blank value in the project name cell in the current row.</strike> I've figured this one out! In my D15 cell: =IF(C15<>"",C15,(IF(G15<>"",E14,""))) where C15 is from my "manual start" entry (for beginning of day), G15 is my project name cell, and E14 is the previous row's stop time.
3) I would like the project name cell to have a drop down to select from a list maintained in a separate worksheet. No entry would be allowed in the cell and could only contain the value selected from the project list.
4) Currently, I do not make entries for my lunch and other breaks, mainly because it would show up in my weekly hours summary. So, if I were to get #2, I would need a way to filter out those breaks from the weekly hours summary.
Doable for a novice? RTFMs / RTFLs are welcomed!
