How to Convert Decimal Time to Hours Minutes Seconds in Excel - Office 365

When working with Excel you might need to convert decimal time to minutes, hours or seconds. In the Excel date system one day is equal to 1 so you can think of time as fractional values of 1. To represent hours divide by 24, minutes divide by 1440 (24X60) and seconds divide by 86400 (24X60X60). To download the example Excel file please click on the link below