Excel - Compute Elapsed Time

preview_player
Показать описание
Compute the elapsed time between a start and end time.
Комментарии
Автор

Hi Rich. I want to calculate end time based on total time spent in the task. For example, a task took 45 mins to complete, the end time should be start time + total time spent. That is what I know, but if the end date moves to the next day then this formula does not work

babam
Автор

the sort function and the unique function do not appear when I type = and start typing them in

wreckingopossum
Автор

Educated about Excel, definitely need some help on the background noise.

anthonyverdin
Автор

Sir what happens when star and end time is two different days

mydigitalspace