Formula to turn days to weeks

Corsenna

New Member
Joined
Jun 24, 2015
Messages
1
I'm working a spreadsheet for a tabletop RPG character sheet and I'm working on making it calculate the healing time based on number and type of wounds taken (bashing takes 3 hours per level, lethal and aggravated are the same time 6 hours for the first level, 2 days for the second and third level, 4 days for the 4th and 5th, and 1 week for the 6th and 7th.)

I have 3 separate cells to display the total weeks, days, and hours.
The problem is I end up with something 1 week, 12 days, 9 hours for example, what I would like to know is if I can make it convert instead to 2 weeks, 5 days, 9 hours?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Assuming Weeks in A2, Days in B2, Hours in C2:

=INT(((A2*7)+B2+(C2/24))/7) & " weeks" & TEXT((A2*7)+B2+(C2/24)-(7*INT(((A2*7)+B2+(C2/24))/7))," d \da\y\s h \hour\s")
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

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