Forum Discussion
Timespan in one cell
I strongly suggest that you try to convince the powers that be that using two separate cells is much, much better. Not only does it make calculating working hours a lot easier, it also helps preventing errors.
If you enter an invalid time in a cell, the result will be an error or a value different from what was intended. But since a value such as 10-19:30 is text, you can enter anything. Moreover, Excel tends to interpret a value such as 8-11 as a date (August 11 or November 8, depending on your regional settings).
I strongly suggest that you try to convince the powers that be that using two separate cells is much, much better. Not only does it make calculating working hours a lot easier, it also helps preventing errors.
If you enter an invalid time in a cell, the result will be an error or a value different from what was intended. But since a value such as 10-19:30 is text, you can enter anything. Moreover, Excel tends to interpret a value such as 8-11 as a date (August 11 or November 8, depending on your regional settings).
