Adding hours and minutes in Excel

  neil_raj 11:59 04 Oct 2007

Hello All.

What's the formula to add hours and minutes in Excel


5.21 + 4.50 = 9.71 BUT in hours (with 60 mins in an hour) this should read 10hrs 11mins, any ideas pls.

Regards......... Neil.

  Picklefactory 13:20 04 Oct 2007

You can't use decimal point when adding/subtracting time, you must seperate hours and mins with a colon : You should be fine then.
Your cells shoud contain 5:21 and 4:50 then when you add it should work.

  Picklefactory 13:23 04 Oct 2007

PS, if you want to show the result as '10hrs:11mins' then change your result cell format to hh"hrs":mm"mins"

  neil_raj 16:20 04 Oct 2007

Thanks that works

regards.... Neil.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?