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