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?
VBAXLMan
Favorite 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
Anonymous
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)