How to convert time by calculation in Excel. To be able to implement this method you first need to remember the unit of time and date conversion as: 1 day = 24 hours. 1 hour = 60 minutes = 3,600 ...