Is there a way to represent a time value in Excel where hours can be 24 and above?
For example, have a time that would be 25:00:00 for 1 AM on the following day (common representation in mass transit scheduling).
It can't just be plain text, because I want to be able to perform calculations on them (averages, standard deviation for example) or chart them.