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?
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?