Calculating age differences
I'm not sure what chronological age and reading age are, but format hh:mm is
definitely NOT years and months but hours and minutes. Try to use format yy/mm
and formula =A1-A2 for the difference.
e.g. 10/01 - 08/5 will result 01/09.
Regards,
Stefi
€žJo€ ezt Ã*rta:
I have two columns: chronilogical age and reading age. I need to calculate
the difference between these ages. Age displayed as eg. 10:01 (10 years and
1 month) actual format is hh:mm.
Please can someone tell me the correct formula?
Thanks
|