Forum Discussion
zaxxon
Jun 14, 2020Copper Contributor
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...
eclipse25
Oct 18, 2022Copper Contributor
Hi, this is very helpful for me. But how about when the days difference is more than 1 please?
SergeiBaklan
Oct 20, 2022Diamond Contributor
I guess it shall work if dates are within same month. If not we shall to know bit more, in which months (and years taking into account leap years) these dates are.