Microsoft Excel Question
Author |
Message |
rar
|
Posted: Wed Jun 09, 2010 10:53 am Post subject: Microsoft Excel Question |
|
|
So I'm trying to keep track of my work hours in Excel (for my own records) and I'm wondering how I can count the hours I work using the cells they are in.
In one cell, I put what time I started, and in the next I put what time I finished.
So it'd be like:
10:00 12:00
I want to get a function that will print "2" for me, meaning it counts the hours I've worked and somehow displays them in number form.
Anyone know how to do this? I'm sure it can't be too hard but I can't figure it out. |
|
|
|
|
|
Sponsor Sponsor
|
|
|
chrisbrown
|
Posted: Wed Jun 09, 2010 11:35 am Post subject: RE:Microsoft Excel Question |
|
|
Excel supports date/time formatting and arithmetic. If you have 10:00 in cell A1 and 12:00 in B1, enter =B1-A1 in another cell. To format it the way you want, right-click it -> Format Cells -> Custom (should be there by default) and in the Type box, enter h (for hours), or h:mm, etc... |
|
|
|
|
|
rar
|
Posted: Wed Jun 09, 2010 12:01 pm Post subject: RE:Microsoft Excel Question |
|
|
Yeah I figured it out, my only problem was adding them but I had to multiply the sum by 24. I had been hoping not to put it in as 24-hour time, but to not do so would require more formula modification and so it's fine the way it is. Thanks anyway! |
|
|
|
|
|
|
|