I have a cell that has a formula in it (F11) the formula produces a number with no decimal places and that number represents a time in minutes. I have another field (K11) which has a time in it. In another field I want to add the minutes of cell F11 to the time in K11.
F11 = 29
K11 = 7:00 AM
When I just add the two cells : =J12+F11 the returned result is 8:42 PM.
Why do I get 8:42 PM?
I need the answer to be 7:29 AM. How do I get that?
Bookmarks