I'm working on a spreadsheet to track how many delivery vans I've loaded each day.
The loading sheets have barcodes at the bottom which I scan into my table. They're in the format T<trip><date_as_yyyymmdd>V<van_number>, i.e. T001A20221024V101.
At work the people on the desk have a spreadsheet...
ABCDEFGHIJKL1DAYDATADATE/TIME2DAY 1E2F2G2H2autofill date/time3E3F3G3H34DAY 2autofill date/time56DAY 3autofill date/time7
Hi, I have tried to post this previously but have yet to get this solved.
I need Excel to automatically FILL-IN and UPDATE the current Date & Time in cell L2 (which is...
Forgive me, I'm new to VBA. I have enough experience in programming, but it's not my bag. I'm currently trying a macro to copy data from one sheet to a table, and that data includes a NOW() function formatted the way I want. When I copy it over to the table, it's just copying the NOW() and I...
I need a macro code inserted into my workbook that will stop the Today() and now() functions from recalculating every time a change is made in the work book. Students will be typing in numbers in columns A and E. When their number is inserted in column A, the "name"(column B), "date"(column C)...
<tbody>
in
8:00
8:00
out
12:30
12:15
in
13:30
13:15
out
17:30
total
8:30
6:37
15:37
15:37
</tbody>
function for the first total (in cell B10)=IF(ISBLANK(B6:B9),"0",IF(ISBLANK(B7:B9),NOW()-B6,IF(ISBLANK(B8:B9),B7-B6,IF(ISBLANK(B9),(NOW()-B8)+(B7-B6),(B9-B8)+(B7-B6)))))...
Hi Guys, I hope you are all well.
I was just wondering if anyone can help me I am just looking for a simple sub that simply puts the Application.Username in column E and Date and Time in Column F each time the macro is used and will create a list of Users And Login Times.
any help would be...
Hi,
I'm currently building a data model for my work, I've built a giant =IFS statement to return a value based on the current time:
=IFS(AND(F3>=TIMEVALUE("00:00 AM"),F3<TIMEVALUE("00:15 AM")),"00:00 - 00:15",AND(F3>=TIMEVALUE("12:15 AM"),F3<TIMEVALUE("12:30 AM")),"00:15 - 00:30" ... "23:45 -...
So, I need to keep the NOW() and TODAY() from changing every time I change a cell or open the spreadsheet. I need the columns C, (TODAY()), F and G (NOW()) to stop updating once there is a time or date in the column. Thank you for the help! If you need anymore information Let me know.
Hi,
I am looking to work out if a list of items have been Completed, Due or Overdue.
For completed, it should be in last: 24h, 48h, 72h, 5 days, 10 days.
For Due, it should be in next: 24h, 48h, 72h, 5 days, 10 days, more than 10 days.
For Overdue, it should be overdue by: 24h 48h 72h, 5 days...
Hail Excel-lent ones. I've used this site often in the past to much success, but I've found a problem I'm not sure how to work around.
I need two independent time stamps to be auto-filled based on the completion of adjacent cells. This part works in generating the stamps, but updates when the...
Hi Guys,
I have a cell on sheet 1 which updates every second with the current time. the format of this cell is hh:mm:ss. I then have a sheet with cells for different premises again with the format hh:mm:ss. I have a command button for each premises on a page. However, i dont want anyone to be...
I've been using excel for a few years now, I'm a little familiar with alot of things, but perhaps rusty when it comes to more indepth/technical stuff. Macros and VBA dont completely scare me, but I couldnt begin to start writing my own code from scratch.
I'm going to have a large database of...
Firstly sorry for my to you easy to me impossible problem.
Working in dairy need others to enter each cows daily milk production. Want form for cow by cow entry.
Row 1 Date
Colomn A cow's id no
Colomn B cows name(vlookup on form)
C: Amount of milk
VB to update now() for column, entered id...
Hi all, I have a very basic background in macros but I am attempting to create a macro that when the button is pushed, a spreadsheet will track what time it was pushed at. Does anyone have suggestions? At this point I have just tried recording the macro by doing that, but on the spreadsheet I'm...
Hi,
I have a form I created for my office that uses Excel 2007. To create a unique ID for each form completed I created a formula that takes the name entered in one cell and concatenates it with the date & time in the adjacent cell. The date and time is calculated using the NOW() function in...
Hey everyone! Thanks for any input on this issue I'm having.
I have a workbook that has assignments that get done throughout the month. I need the date to autopopulate based on criteria so I am using the IF() and NOW() functions. The date populates fine, except if I save and close and then...
Hi Team,
Is there a way to capture the system date and time by way of formula without it updating each day? Rather than having to use the =Now() function and then copying and pasting it as a value.
Cheers :eeek:
I'm puzzled by the problem I'm having:
I want to save the current sheet as a PDF with the filename "Receipt YYYY-MM-DD HH:MM.pdf" (That is YEAR-MONTH-DAY HOUR:MINUTE)
I have this working:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"S:\ ...\Receipt " & Format(Now...
i get in my work sheet prices updated from exchange in row 2 every minutes
for 30 cells i.e.from cell A2 to Z2
i want to copy value of this row copied every 15 minutes in same worksheet
from row 3 onwards( or new rows ) for study of rate changes every minutes
i use excel 2007
thank you for...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.