|  

» Adding a Number to a Formatted Time Value

Problem:

Creating a formula that will return a time value which is
the sum of the time in A2 and the number of hours in B2.

Solution:
When adding a time value and a number representing hours, we must first divide the number by 24, as shown in the following formula:
=A2+B2/24
Ensure that the result cell is formatted [hh]:mm to correctly display a time.


Time_____Hours to Add___Result
10:30____4.5____________15:00
17:00____5.2____________22:12
14:12____0.6____________14:48
Screenshot // Adding a Number to a Formatted Time Value
Adding a Number to a Formatted Time Value
Rate This Tip
12 34 5
Rating: 4.22     Views: 37340
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments