Excel tip: Excel treats times as fractions of a day – so they can be used in formulas. I can enter the start time of an event in one cell and the end time in another cell. If I subtract the start time from the end time, Excel will calculate the length of the event in hours, minutes and seconds.