Assignment 16 Date Function Cyber Cafe

 

Assignment 16

Date Function

Cyber Cafe

Function Used

IF :- IF function can perform a logical test and return one value for a true result and another for a false result it use to manuplate return the value "TRUE" and "FALSE".

NOW :- this function return the current date and time, updated continuously when a worksheet is change or opened.

HOUR :- this function return the hour component of a number 0-23 for example with a time of 9:30 am hours will return 9.

MINUTE :- The minute function extract the minute component of a time as a number between 0-59 for example with a time of 9:45 am, minute will be return 45.

Function for Status

=IF(E2>NOW(),"In use","Free")

This function use for print computer status like in use or free.

Function for Duration

=E2-D2

E2 is cell address of out time and D2 is cell address of in time.

Function for Amount

=Hour(G2)*50+IF(MINUTE(G2)<=20,15,IF(MINUTE(G2)<=40,25,50))

Print amount of computer according to used time.

Note :-

If the number of minute greater than or equal to 20 the charge will be 15 rupees. if the number of minute less than 20 and greater than or equal to 40 the charge will be 25 rupees. if the number of minute less than 40 the charge will be 50 rupees. if the number of hour less than or equal to 1 the amount will be 50 plus the amount of money based on number of minute.