Changing of Times

[ru_1985]

Hi all,
How can i change the times from 12am to 11pm ask The date will keep on changing wants the user key in a new date.

Example:
2006/09/01 00:00


All the times is requires to change to 11pm.

 

[Richard Schollar]

Hi

Enter:

=23/24

In a cell. This gives the propertion of a day that 11pm represents.

Copy this cell. Select the cells with the times you want to change.

Click Edit>PasteSpecial>Add.

This will amend the date/times to 11pm for each day assuming they all started at 00:00).

Best regards

Richard

 

[ru_1985]

The code work great.. Thank