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).
catherine9910 I suspect he end time is 12 hours after the start time, but it goes over midnight. You need to use a formula like:
=MOD(endtime-starttime,1)
That works for all time-lapses you want to calculate.