View Single Post
  #1   Report Post  
Tanya
 
Posts: n/a
Default sum of date ranges

I have the formula to calcuate date ranges which are returned in the
following format:
C D E
2 0years 4months 9days worked in Dept. A
3 4years 2months 15days worked in Dept. B
4 28years 8months 30days worked in Dept. C

What formula would I use to calculate the total number of years worked in
all three departments?