Forum Discussion
Time-Lapse Help
Hello, I am trying to do a time-lapse formula and I get ###### that goes on forever (example below). How do I fix this (the employees don't know or use 24-hour times).
bosinander when I type in =MOD(B5-A5;1) I get the error message. How are you able to do you that without the error?
Perhaps in your locale it'll be
=MOD(B5-A5,1)It's better to copy formulae from file, not from post.