| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Total Number of Days
I am required to maintain a log of the amount if time I work on different
projects. At the end of a month (and YTD) I need to calculate the total number of month, days, hours and minutes I have spent on each project. I have been using the SUM function, which works fine. But, I cannot figure out the proper formating for the cell to have it display months:days:hours:minutes. Has anyone solved this problem? Thank you for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total number of days between 2 dates | New Users to Excel | |||
| Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
| how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
| Convert Percentage to total number of NPT Days | Excel Worksheet Functions | |||
| how do i display the total number of days in the current month in. | Excel Discussion (Misc queries) | |||
Threaded Mode
