Hello All,
I'm trying to total the number days elapsed for Projects worked in a month in DD HH:MM:SS format. When the days total < 31 days, the forumula calculates correctly, but if it's greater, the days start over again at 1.
How do I display the Total Project hours added in a month displayed in DD HH:MM:SS for hours totaling over >31 days.
Please see attached spreadsheet. I have a sample of Projects completed in December and January.
The table in December is showing the correct since the days totaled are < 31 days, but the table in January is not showing correctly.
Elapsed Time Wks.xlsx
Thanks!
Regards,
Andy
Bookmarks