=TIME(Hours,Minutes,Seconds) Times is necessarily a decimal value In Excel, hours are always a fraction of a day. So it is necessarily decimal numbers (ALWAYS). This rule is fundamental to avoid mistakes in calculation and display. For instance, in the following picture, we have the value 0.5 in a cell. If we change the format number to the Time format, we have 12 hours this time. This is logical because 12 hours is the middle of the day, so 0.5 day 😉 Most people use integer numbers to write their time values. It's a fact that writing a time in Excel is not easy because you must use the symbol colon ( : ), like 12:00:00. Many people prefer to write the value 12 (an integer number). But when you apply a Time format to an integer number, the only result you have it's 00:00:00 😱😱😱 TIME function to transform your […]