In MS Excel, How do I create a formula to convert 56.25 weeks into days and hours?

Question

what I need is to convert it into the number of Days and Hours equivalent to 56.25 weeks. So, the result should end up being 393 days 18 hours.

Answer 1

...... Column A.... Column B........ Column C
Row1..# of Wks.....# of Days.........# of Hrs
Row2 56.25........ type: =A2*7.... type: =B2*24

Answer 2

Convert Weeks To Days

Answer 3

56.25 in cell A1
Following formula in cell A2
=FLOOR(A1*7,1)&" Days and "&MOD(A1*7,1)*24&" Hours"

=FLOOR(A1*7,1) multiples to convert from weeks to days and then removes the decimals from the equation, giving you only days.

MOD(A1*7,1) gives you the remainder after you divide the number of days by 1; result is .75, then multiply by 24 to convert from partial day to hours.

I added the &" Days" and &" Hours" bits to put it all in one equation.

Good luck; hope this helps.

Answer 4

click in a box (cell), type

= 7 * (and now click in box with the 56.25 weeks in it)

now press enter

that's the box for number of days

now click in a new cell, type = 24 * (and now click on the cell you previously made, the cell for the number of days...)

and hit enter.

that's it

Answer 5

=INT(A1/7)&" week(s) and "&7*MOD(A1/7,a million)&" days" fee must be in A1, or you may exchange A1 to the different cellular. may additionally chop up the formulation up into diverse cells in case you elect. or in simple terms exchange A1 on your fee.