How to ADD Decimal to Time in MS Excel? -


Is it possible to create a formula that will take a price from the column which is the time format and the decimal from the other Column which will evaluate in a new time format? How is that?

For example:

  _________________________________________________ | A. B C. -------------------------------------------------- 1 | Departure time. Hour period Arrival time 2 | 7:00 AM | 2.78 | = SUM (A2 + B2). 3 | 7:00 AM | 1.33 | = SUM (A3 + B3). 4 | 7:00 AM | 6.98 | = SUM (A4 + B4). 5 | 7:00 AM | 2.50 | 9:30 pm |  

The above hours are in column format format and in the timing format of departures and arrival (h: mm am / pm). In line 5, the duration of the hour is "2.50", which is 2 hours and 30 minutes (not 2 hours and 50 minutes) - then (7:00 AM + 2.50) should be the result of 9: 30 PM.

In the above example, formulas do not work in column C, but hopefully what I am thinking to meet the expectations. For example

C2

  = A2 + B2/24  

and format in C2 in time format.


Comments

Popular posts from this blog

Member with no value in F# -

java - Joda Time Interval Not returning what I expect -

c# - Showing a SelectedItem's Property -