this updates to the current date but i want it to save the time do static once it reaches complete.
I would much appreciate the help
Hello Louise, there is two ways of doing this. Try the one that suits your needs the best.
Put this macro in your MyExcelNameHere.xls or other startup workbook. Attach it
to a toolbar button, or give it a keyboard shortcut.
Public Sub ExtendedTime() If TypeOf Selection Is Range Then With ActiveCell .NumberFormat = "hh:mm:ss" .Value = Time End With End If End Sub
Or the second way -
You would have to create a macro, the easiest form of macro for this
would be an event macro. You could trigger it on replacing an empty
cell in a specific column, or when another column is filled in.
DateTimeStamp in Column A, on first entry in any other column on row (#datetimestamp)
Place current date constant in Column A when Column B changes (#autodate)
The following will put the time into Column B when an entry is made in Column A
install by right click on sheet tab, View code, .place the following code there.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 1Then Exit Sub If Target.Row = 1 Then Exit Sub If IsEmpty(Target.Offset(0, 1)) Then Target.Offset(0, 1) = Time Target.offset(0, 1).numberformat = "hh:mm:ss.00" End If End Sub
I am developing a simple job card creator application with VB.net 2012, using Access 2010 as database.
The code I have generated to write data from a datagridview to the database table is successfully saving the data, but with an error "Parameter @name has no default value". The ...
write a C++ program which take inputs from the user/keyboard and calculate his ZAKAT.
get the input from user may include
-Amount invested in business
-Amount given to other business partners as loan
-Amount payable to others
I made a prime number finder, it finds the nearest prime that is above and below any integer (Does not work that well with giant numbers.)
Made this in cpp.sh
Why would I need the x=y+1-1;?
x=y; just doesnt seem to work
Why is this?
And I know my coding ...