Forum Discussion
Janedb
Jan 20, 2025Iron Contributor
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.
- Jan 20, 2025
See the attached version.
Janedb
Jan 20, 2025Iron Contributor
Hi Riny thank you, can you help with converting the days into months?
HansVogelaar
Jan 20, 2025MVP
Your workbook is about hours worked. What is a month in that context? January has 31 days and February has 28 (sometimes 29) days.
- JanedbJan 20, 2025Iron Contributor
I work on an average of 30.41 days in a month (365/12)
- HansVogelaarJan 20, 2025MVP
See the attached version.
- JanedbJan 20, 2025Iron Contributor
Thank you very much!!