I am trying to make a spreadsheet for work. I am experienced with excel
and VB but cant get 3 items to work on my spreadsheet. Every time
someone brings a item into my shop to be tested it will be added to
this log.
First, I would like to have a date to be automatically entered in cell
G1 and a time in H1 when anything is put in cell C1. I tied the now
function but I would like the date not to change when C2 C3 and so on
are filled out.
Example
A1 B1 Initials(C1) D1 E1 F1 Date(G1) Time(H1)




Second I would like the first row after the header to be blank. After
a person adds a row of data can a new row be automatically be inserted
above it?

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.

sorry if this is totaly out there :) but any help would be great.


--
Tuck
------------------------------------------------------------------------
Tuck's Profile: http://www.excelforum.com/member.php...o&userid=34055
View this thread: http://www.excelforum.com/showthread...hreadid=538176