So I am have a problem in excel, where I have to add time higher that 24 hours and also convert the minutes to decimal.
so for a period of 4 months I need to total the following:
Jan - 717:21
Feb - 636:32
Mar - 825:21
Apr - 601:15
and after totaling this the minutes need to be converted to decimal.
so it would read 2780 hours and 29 minutes, but the minutes must be displayed as a decimal.