Forum Discussion
calculating elapsed time - unique cell formula dd hh:mm:ss
hi, i need to calculate elapsed time between cells. total time that has passed in hours:mins:ss the cells are formatted like this: dd hh:mm:ss i tried a custom format on the cell but its...
zaxxon Take a look at the attached workbook. The result column is for your presentation purpose of hh:mm:ss so please note that it is not recommended to use that column for any calculation. Instead use column E if you need further calculation.
Your Start and End cells contain only DD but not information about month, year so I assume same month, same year and just calculate the time difference. If this assumption is not correct, the formula will need to be revised.
Really cool stuff you've done here! Curious what the revision to the formula might look like if these are not all the same month. For example, several rows produce a negative time column (when the assumption is made). Pls help