Adding hours and minutes in Excel

  neil_raj 11:59 04 Oct 07

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 07

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 07

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 07

Thanks that works

regards.... Neil.

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

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…