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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

How to use 3D Touch on iPhone

Comment importer des contacts d’un iPhone à un autre iPhone ?