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.
Prevent =NOW() value from changing
Prevent =NOW() value from changing
Last edited by MrProgrammer on Mon Jan 06, 2020 3:11 am, edited 1 time in total.
Reason: Changed title, was: Functions In Calc
Reason: Changed title, was: Functions In Calc
Openoffice 4.1.7
Windows 10 Pro
Windows 10 Pro
Re: Functions In Calc
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 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.
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.
Re: Prevent =NOW() value from changing
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Prevent =NOW() value from changing
They are the location for Parcells pick up and delivery. Those cells are just simple text.
Openoffice 4.1.7
Windows 10 Pro
Windows 10 Pro
Re: Prevent =NOW() value from changing
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.
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.
Re: Prevent =NOW() value from changing
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.
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 107 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice