Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.
How to change the default Date format when you insert a date in a cell. The technique is explained in this article
Discover how to customize easily your date format in Excel by changing the day, month or year. Many example.