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).
- Thanks a lot Hans and sorry for the delay in reacting. Yes, you are absolutely right. I ended up using letter codes (the shifts are almost always on same hours such as 14-22) and if-function. So fat seems to work well. Thanks.
