Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
I need an MS Excel Formula that generates the total time taken from a list of times.?
Example.
I have a list of times (clock times) and I need to get the total time (duration).
5:30 am
5:45 am
6:15 am
6:30 am
The total duration time spent should be 1 hour and 15 mins or 75min.
Can I get an excel formula that does the above?
2 Answers
- VBAXLManLv 61 decade agoFavorite Answer
I am not sure if I got you correct here, but let me try this...
Option 1:
Now, if you have that list starting from cell A1 down
Paste this in B1
=MINUTE(A1)+HOUR( A1)*60&"min"
Then paste this down to get the others
That is one possibility answer to your question
Option 2:
Another one is this
=HOUR( A1)&" hours and "&minute(A1)&" min"
Option 3:
Or this
=SUM(A:A)
Let me know
VBAXLMan
- Anonymous1 decade ago
Not with the information you gave, to calculate duration, you need a start time and ending time, and you do not specify which times are start and which are end.
If A1 is end time and A2 is start time and
if B1 is end time and B2 is start time
In A3 put =(A2-A1)+(B2-B1)
