Excel has several custom formatting options for duration of time, and it will recognize most times you enter, provided you use a colon between the hours, minutes and seconds.

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

Q. We receive Excel-based reports from our European operations with the daily temperatures of our electrical generators and other equipment recorded in Celsius; what’s the best way to convert these ...