Days

FinancialAnalystKid

Well-known Member
Joined
Oct 14, 2004
Messages
779
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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,213,513
Messages
6,114,072
Members
448,546
Latest member
KH Consulting

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top