Adding days and hours

[Kevin K.]

Hey all, I work in a jail tracking inmate sentences and credit, and I would like to have a way to add 3 sets of days and hours together and come up with a total days and hours (less than 24). Say, 12 days 7 hours + 57 days 22 hours +114 days 17 hours. I can (and have been) doing it all by hand, but I thought 'why?'

I'm not much of an Excel guru and would appreciate the help. Thanks!

[daddylonglegs]

If you put the days in column A (just numbers) and hours as numbers too in column B, e.g for your example "Days" as header in A1, 12, 57 and 114 in A2 to A4 then "Hours" in B1 with 7, 22 and 17 in B2:B4

For totals use this formula in A5

=SUM(A2:A4)+INT(SUM(B2:B4)/24)

...and this one in B5

=MOD(SUM(B2:B4),24)

[samba_ravi]

pls attach sample excel file

[Kevin K.]

Works great. Thank you!