Prevent =NOW() value from changing

Discuss the spreadsheet application

Prevent =NOW() value from changing

Postby rfunstin » Mon Jan 06, 2020 2:21 am

Hello all. I am trying to set up a dispatch sheet for a delivery company. I would like to be able to automatically have the time the call came in, the time it was dispatched and the time the driver cleared to be easily added. I doubt that it there is a formula or macro that would make it as easy as hitting the enter key for out dispatcher. I have used the =NOW() function but I don't want the time to change.
Layout is;
Time in | Driver# | Time Out | Pick up | Drop Off | Time Clear | Amount

This information is beneficial to track how long it is taking for dispatchers to send out call and how long drivers are taking. Any help would be great.
Last edited by MrProgrammer on Mon Jan 06, 2020 3:11 am, edited 1 time in total.
Reason: Changed title, was: Functions In Calc
Openoffice 4.1.7
Windows 10 Pro
rfunstin
 
Posts: 2
Joined: Mon Jan 06, 2020 2:08 am

Re: Functions In Calc

Postby RusselB » Mon Jan 06, 2020 2:39 am

Welcome to the Forums.
OpenOffice does not have a sequence to allow quick persistent entry of dates/times, thus the only option in OpenOffice is to use the =NOW() function, then follow it with a Ctrl+C, then Ctrl+Shift+V with Formulas being unchecked in the Paste Special dialog.
In LibreOffice use Ctrl+Shift+; to get the current date & time. If you only want the time, just format your column to show just the time portion.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6156
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Prevent =NOW() value from changing

Postby Villeroy » Mon Jan 06, 2020 12:42 pm

What are "Pick Up" and "Drop Off". Times? Durations (minutes)? Weighs? Text?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28641
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Prevent =NOW() value from changing

Postby rfunstin » Mon Jan 06, 2020 3:48 pm

They are the location for Parcells pick up and delivery. Those cells are just simple text.
Openoffice 4.1.7
Windows 10 Pro
rfunstin
 
Posts: 2
Joined: Mon Jan 06, 2020 2:08 am

Re: Prevent =NOW() value from changing

Postby RusselB » Mon Jan 06, 2020 6:31 pm

If they are times, then they should be numbers, not text.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6156
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Prevent =NOW() value from changing

Postby Villeroy » Mon Jan 06, 2020 9:23 pm

Have a look at the attached database.
Open the database document and the input form therein.

There is a list of drivers stored in table "Drivers". Every time a driver comes in, you enter the incoming driver name into the top left listbox.
When you click the refresh button, the overview table will update. The table grid shows the drivers that are inside with a time stamp (date and time).
When a driver changes drives outside, you click on one of the the radio buttons "PICK UP" or "DROP" and enter some text.
When you click the refresh button, the overview table will update. The table grid shows the drivers that are out with an time when they left and the duration in hours. The PICK column shows no value for drivers that are in, a check mark for drivers that are out for pick up and an unchecked box for drivers that are out for delivery.
The easiest way to filter the table with 2 clicks:
Click any value in the grid, for instance a blank out time, and then click the auto-filter button. Now you see all rows of drivers that are inside. Click a check mark to auto-filter pick ups and an unchecked value for deliveries. Or click a driver name and then auto-filter to show all states of that driver.
The sort order is "frozen". Latest in-drivers appear on top.
Attachments
Drivers.odb
(15.72 KiB) Downloaded 16 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28641
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: Zizi64 and 23 guests