Hi, I've got a worksheet attached where I'm trying to sum decimal numbers but have the end result appear in hours and minutes. For example, 5 cells have 1.25 (1 hour and 25 Minutes) each and when added I'm trying to make them equal 7:05 to reflect the hours and minutes involved. Please note, there could be hours and minutes which are higher than 60 as well like 2:80 as a random example. So two cells with 2.80 would effectively equal 6.40 when added. Is there a formula which would help me achieve this? Thanks, JL.
Bookmarks