C Carolina Girl Dec 29, 2008 #1 Please help…. What is the formula to convert 1.0 days into 8.0 hours???? Thank you in advance
B barry houdini Dec 29, 2008 #2 Please help…. What is the formula to convert 1.0 days into 8.0 hours???? Thank you in advance Click to expand... If you have the number of days in A1 then perhaps =A1*8 to get 8......or if you want 8:00 in time format then use =A1*8/24 format result cell to show as time, i.e [h]:mm
Please help…. What is the formula to convert 1.0 days into 8.0 hours???? Thank you in advance Click to expand... If you have the number of days in A1 then perhaps =A1*8 to get 8......or if you want 8:00 in time format then use =A1*8/24 format result cell to show as time, i.e [h]:mm
