| |
You are here: Experts > Computing/Technology > Microsoft Software > Excel > Accumulated Minutes into Hours & Minutes
Excel - Accumulated Minutes into Hours & Minutes
Expert: Stuart Resnick - 10/30/2009
Question
I need to accumulate minutes and then show them in an Hour/Minute format using a 24 hour clock.
Example:
Time On: Time Off: Elapsed Hours/Minutes: Accumulated hrs/mins:
0619 0622 3 minutes 3 minutes
1457 1809 12 minutes 15 minutes
0038 0138 1 hr 1 hr 18 mins
I can calculate the Elapsed Hours/Minutes by using =(E3-D3)*1440. But I am having difficulty with changing the Accumulated Hrs/Minutes in showing Hours %26 Minutes, I only get accumulated minutes and it rolls back to zero after a 24 hour period.
Answer
Since you don't specify, I'll assume Excel 2003.
Select cols A:B and Format, Cells, Number, Category: Custom, Type: hhmm, OK.
In cell A1 enter
06:19
and it will appear as 0619. Similarly, enter the rest of the times in A1:B3.
Select cols C:D and Format, Cells, Number, Category: Custom, Type: h "hr" mm "minutes", OK.
In C1 enter
=B1-A1
In D1 enter
=SUM(C$1:C1)
Then copy C1:D1 down the cols
Add to this Answer Ask a Question
|
|
