# Days

#### FinancialAnalystKid

##### Well-known Member
I'm trying to track HOURS and after 24 I want a cell to show 1 day, 2 days etc.

TOTAL
A1 = Days
B1 = Hours
C1 = Minutes
D1 = Seconds

Cells B5 thru B200 will have hours entered like 1:01:02 and even past 12 hours like 13:05:00 or even 50:00:00.

I'm totaling B5:B200 and need A1 to reflect days, b1 hours, etc.

If the sum of b5:b200 is 73:59:01 I want the display to sho:
A1=3 (days)
B1=1 (hours)
C1=59 (minutes)
D1=1 (seconds)

I can get everything but the Days part.

Check this if it is right:
A1=???
B1=HOUR(SUM(B5:B200)
C1=MINUTE(SUM(B5:B200)
D1=SECOND(SUM(B5:B200)

Is this correct?

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
a1 = a1/24
then format the cell [h]

Replies
2
Views
429
Replies
6
Views
643
Replies
7
Views
563
Replies
1
Views
369
Replies
6
Views
252

1,219,820
Messages
6,150,408
Members
450,960
Latest member
GB2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back