Generate a serial number for events with dates

Closed
Report
-
 degree101 -
Helllo, I have a problem of generating a serial number from an event on the spreadsheet that has date of event and time, amount. how do i get the formular to compute the the corresponding slip id how do you compute such assuming it is represented in the spreadsheet like this


From: 14.11.16 00:00 To: 18.11.16 00:00

SLIP ID REG DATE ADMIN STAKE TO REGISTER STATUS IS WON? P.R.
... 14.11.16 21:43 1000.0 YES Accepted WON 1408.75





Thanks
Ray



2 replies

Posts
17733
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
December 2, 2021
5
Can you describe what you will do with the slip id?
the slip id where correctly displayed would be keyed in into a java enabled software to show those various amount. for example, The table below That is the slip ID or serial number 3894525859 generated from such spreadsheet. How was such computed Making use of dates and time. Will the DATE VALUE FXN OR TIMEVAUE FXN or any other one do it and what would be the formular.


From: 15.11.16 00:00 To: 16.11.16 00:00

Slip ID Reg. date STAKE C.R. Decided date Cashier name
3894525859 14.11.16 03:20 990 0 15.11.16 02:17

Earnestly waiting for your reply ASAP

RAY