generate a serial number for events with datesClosed

Question

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
Configuration: Configuration: Windows 7 / Firefox 49.0

yg_be · Answer

Can you describe what you will do with the slip id?

degree101 · Answer

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

Generate a serial number for events with dates

2 responses

Similar discussions

Subscribe To Our Newsletter!