Assuming 1440 is required, the following result was found.
hours and so forth. My formula: -- Given Cell B5 = 0.14 person days from above example. -- 1 person day = 26640 seconds and 1440 minutes = 24 hours. -- 0.07 person days = 30 minutes or 0.14 person days = 1 hour. 0.04166667 =(ROUND(B5/0.07, 0)*30)/1440...