Forum Discussion
Solved
Converting hours into days and hours
Hi all, I have a formula that calculates the days and hours from total hours worked. The formula is working but the total does not want to add the total days and hours worked.
See the attached version.
That's because the formula in column I generates texts and the SUM of texts returns zero. you need to add the total hours first and then apply the same (or a similar) formula in the total row.
Hi Riny thank you, can you help with converting the days into months?
Your workbook is about hours worked. What is a month in that context? January has 31 days and February has 28 (sometimes 29) days.
I work on an average of 30.41 days in a month (365/12)
