add hour and minute to date with time

[mazan2010]

please can edit in my formula in cell B5 that i want to add 4:31 in A4 to E1
its 4 hours and 31 minute

[AliGW]

It's simple, isn't it?

=E1+A4

Result: 02-Jun-17 00:41

[mazan2010]

yes its work but why TIME(A4,A4,0) not work
becasue if i want add only minute or hour only what can i do

[AliGW]

That's a different question. I have answered the one you asked.

Let's start again: what EXACTLY are you trying to do? Check these out:

=MINUTE(A4)

=HOUR(A4)

[mazan2010]

please can see my attached file in cell B5 its not correct although add hour only

[AliGW]

This:

=E1+TIME(HOUR(A4),0,0)

[AliGW]

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.