Re: a few questions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


thx a lot bob. with the 2 codes you gave me, i only need the bottom one
right? they look the same except that the bottom one incerts the line.
I also got erros and noticed 3 "m"s in the date. i changed it to 2 and
the error dosent show up any more but either way i didnt get the dates
to enter after filling in C1. Im not really sure how the code works so
dont even know where to start trouble shooting it.

I have an equation for the time in shop (shown below) when a new line
is incerted is there a way for that code to show up in the new inserted
line?


Finally I am trying to do a total time in the shop column. In this
column the date and time out would be subtracted from the date and
time
in to give me the total time in the shop.
This is what I have now
=IF(G2+I2=0," ",IF(G2+I2=G2,"In Progress",((I2+J2)-(G2+H2))))
but the answer always adds a day. If its only an hour difference in
time and date I get 1//0/00 1:00 for a total time in shop. What am I
doing wrong here.

This works for me. How are you entering the date and time?


im entering my date and time as 5/2/06 2:00 and 5/2/06 3:00 and i get
the 1/0/00 1:00 as my reply


--
Tuck
------------------------------------------------------------------------
Tuck's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34055
View this thread: http://www.excelforum.com/showthread.php?threadid=538176

.

Relevant Pages

  • Re: more closed-world chatter
    ... This exact question has been in the back of my head for ... the bottom; I am inclined to prefer the bottom. ... Regarding possible answers, I took it that both Bob B and Jon H are amenable to an answer of "false", assuming the dbms doesn't take exception and refuse to answer. ...
    (comp.databases.theory)
  • Re: Need Symbol to Indicate a Space in a Computer Address String
    ... Hi Bob, ... set the font to Lucida Sans Unicode. ... >Thank you Suzanne for your response. ... >the insert carat that is on the bottom of the line specifically like when you ...
    (microsoft.public.word.docmanagement)
  • Re: Need help writing formula plz..
    ... all AutoSum at the bottom of the column giving me the total of the data for ... "Bob Tarburton" wrote: ... Say I have 5 columns of data and it goes down for 29 cells for the day ...
    (microsoft.public.excel.misc)
  • Re: a few questions
    ... after the header row, to preserve a blank row, as well as the date time ... Bob Phillips ... they look the same except that the bottom one incerts the line. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: XP SP2 Task bar has shrunk vertically
    ... Bob S wrote: ... could see it at the bottom of my screen. ... problem with the vertical position or height of my monitor. ... Can anyone help me find my task bar? ...
    (microsoft.public.windowsxp.general)