Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
I'm very new at excel. trying to self learn. I've read many post regarding
times. I not sure if i'm seeing the answers i'm looking for. I do security patrols. I am looking for a way to calculate how long a patrol takes. I'm explain what i'm looking for. First: is there a way to just click on a cell and have the now time appear. Then click on a 2nd cell, and have the now time appear without changing the 1st time. Then have the total automaticly add. A B C Arrive Clear Total 22:35 22:55 20min 23:45 00:55 1:10 It needs to be able to add past midnight. If anyone can help i would really appreciate it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
trt this formatted as hh:mm
=B1-A1 + (B1<A1) Mike "doss04" wrote: I'm very new at excel. trying to self learn. I've read many post regarding times. I not sure if i'm seeing the answers i'm looking for. I do security patrols. I am looking for a way to calculate how long a patrol takes. I'm explain what i'm looking for. First: is there a way to just click on a cell and have the now time appear. Then click on a 2nd cell, and have the now time appear without changing the 1st time. Then have the total automaticly add. A B C Arrive Clear Total 22:35 22:55 20min 23:45 00:55 1:10 It needs to be able to add past midnight. If anyone can help i would really appreciate it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
Thanks for your response. I guess i'm too new. How do i get to the place to
type the format? Hope u have pactience. "Mike H" wrote: trt this formatted as hh:mm =B1-A1 + (B1<A1) Mike "doss04" wrote: I'm very new at excel. trying to self learn. I've read many post regarding times. I not sure if i'm seeing the answers i'm looking for. I do security patrols. I am looking for a way to calculate how long a patrol takes. I'm explain what i'm looking for. First: is there a way to just click on a cell and have the now time appear. Then click on a 2nd cell, and have the now time appear without changing the 1st time. Then have the total automaticly add. A B C Arrive Clear Total 22:35 22:55 20min 23:45 00:55 1:10 It needs to be able to add past midnight. If anyone can help i would really appreciate it. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
No problem, plenty of patience.
Put the formula in a cell and hit Enter. Select the cell again and then Format|Cells Select the 'Number' tab and click on 'Custom' Double click in the 'Type' box and then type hh:mm Click OK and your done. Mike "doss04" wrote: Thanks for your response. I guess i'm too new. How do i get to the place to type the format? Hope u have pactience. "Mike H" wrote: trt this formatted as hh:mm =B1-A1 + (B1<A1) Mike "doss04" wrote: I'm very new at excel. trying to self learn. I've read many post regarding times. I not sure if i'm seeing the answers i'm looking for. I do security patrols. I am looking for a way to calculate how long a patrol takes. I'm explain what i'm looking for. First: is there a way to just click on a cell and have the now time appear. Then click on a 2nd cell, and have the now time appear without changing the 1st time. Then have the total automaticly add. A B C Arrive Clear Total 22:35 22:55 20min 23:45 00:55 1:10 It needs to be able to add past midnight. If anyone can help i would really appreciate it. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
Mike H wrote:
No problem, plenty of patience. Put the formula in a cell and hit Enter. Select the cell again and then Format|Cells Select the 'Number' tab and click on 'Custom' Double click in the 'Type' box and then type hh:mm Click OK and your done. Mike Hi Mike, sorry to hijack this thread but I also am trying to self learn Excel. So, I'm also interested in accomplishing what the OP has asked to have done. If I follow your process, in Excel 2007 I have the option under Number Custom Type of only h:mm, not hh:mm. I assume this to not be a problem. When my cell is formatted in this manner my result is 0:00. If I change the formatting to h:mm AM/PM my result is 12:00. I think what the OP is looking for (correct me if I'm wrong) is to be able to click in a cell and have the current time shown, then click in another cell at a later time and have that current time shown, then have the difference between the first time and the last time be calculated in another cell. I don't see how what you are proposing will do this. If I'm doing something wrong or have misinterpreted the original requirement, let me know thanks, Dave DDP |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
While the Custom Format has some "suggested" custom formats, you can still
add your own by typing them into the Type field above that listing, which is what Mike was directing to be done with this statement... "Double click in the 'Type' box and then type hh:mm" -- Rick (MVP - Excel) "Dave Jones" wrote in message ... Mike H wrote: No problem, plenty of patience. Put the formula in a cell and hit Enter. Select the cell again and then Format|Cells Select the 'Number' tab and click on 'Custom' Double click in the 'Type' box and then type hh:mm Click OK and your done. Mike Hi Mike, sorry to hijack this thread but I also am trying to self learn Excel. So, I'm also interested in accomplishing what the OP has asked to have done. If I follow your process, in Excel 2007 I have the option under Number Custom Type of only h:mm, not hh:mm. I assume this to not be a problem. When my cell is formatted in this manner my result is 0:00. If I change the formatting to h:mm AM/PM my result is 12:00. I think what the OP is looking for (correct me if I'm wrong) is to be able to click in a cell and have the current time shown, then click in another cell at a later time and have that current time shown, then have the difference between the first time and the last time be calculated in another cell. I don't see how what you are proposing will do this. If I'm doing something wrong or have misinterpreted the original requirement, let me know thanks, Dave DDP |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
Rick Rothstein wrote:
While the Custom Format has some "suggested" custom formats, you can still add your own by typing them into the Type field above that listing, which is what Mike was directing to be done with this statement... "Double click in the 'Type' box and then type hh:mm" OK, so that's how one would format the number in the cell. I'm interested if it's possible to click in the cell and have it result in the current time. Dave DDP |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
There is nothing built in to do that, and while we could come up with
something similar in VB, the easiest way to enter the current time (rounded down to the nearest minute which is what the OP showed) in a cell is to key in Ctrl+Shift+; (that is, the Control key plus the Shift key plus the semi-colon key). -- Rick (MVP - Excel) "Dave Jones" wrote in message ... Rick Rothstein wrote: While the Custom Format has some "suggested" custom formats, you can still add your own by typing them into the Type field above that listing, which is what Mike was directing to be done with this statement... "Double click in the 'Type' box and then type hh:mm" OK, so that's how one would format the number in the cell. I'm interested if it's possible to click in the cell and have it result in the current time. Dave DDP |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
Control colon or =NOW().
The latter will update, but the formula will stick at the time you did it. -- David Biddulph "Dave Jones" wrote in message ... OK, so that's how one would format the number in the cell. I'm interested if it's possible to click in the cell and have it result in the current time. Dave DDP Rick Rothstein wrote: While the Custom Format has some "suggested" custom formats, you can still add your own by typing them into the Type field above that listing, which is what Mike was directing to be done with this statement... "Double click in the 'Type' box and then type hh:mm" |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused. Please help.
Mistype there. It should have said:
"Control colon or =NOW(). The latter will update, but the *former* will stick at the time you did it." -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Control colon or =NOW(). The latter will update, but the formula will stick at the time you did it. -- David Biddulph "Dave Jones" wrote in message ... OK, so that's how one would format the number in the cell. I'm interested if it's possible to click in the cell and have it result in the current time. Dave DDP Rick Rothstein wrote: While the Custom Format has some "suggested" custom formats, you can still add your own by typing them into the Type field above that listing, which is what Mike was directing to be done with this statement... "Double click in the 'Type' box and then type hh:mm" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm still confused | Excel Worksheet Functions | |||
Confused | New Users to Excel | |||
confused,please help | Excel Discussion (Misc queries) | |||
:S confused :S | Excel Discussion (Misc queries) | |||
:S confused :S | Charts and Charting in Excel |