If this is still open, =MOD(end_time-start_time,1), but that raises the question whether start_time = end_time should be no elapsed time or exactly 24 hours.
Always best to use DATE and time even if it needs to be formatted only as time.
If this is still open, =MOD(end_time-start_time,1), but that raises the question whether start_time = end_time should be no elapsed time or exactly 24 hours.
Always best to use DATE and time even if it needs to be formatted only as time.
Last edited by hrlngrv; 10-28-2020 at 02:08 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks