- Joined
- Oct 14, 2015
- Messages
- 11
- Reaction score
- 0
- Points
- 1
- Location
- Long Beach, CA
- Your Mac's Specs
- iPhone 6+, Apple TV, iPad Mini, MacBook Pro
Hi. I have searched for a few hours and have tried several methods all without luck. I have a cell (P12) that has a decimal time, say 3.1 and I need to sum that decimal time with another cell (J12) that has time displayed in as HH:MM. This calculation would be displayed in K12. Example below:
J12 = 09:06
P12 = 3.1 (3 hours 6 minutes)
K12 = would have the sum of J12 + P12 displayed as hh:mm
Anyone know how this can be accomplished? Thank you in advance!
J12 = 09:06
P12 = 3.1 (3 hours 6 minutes)
K12 = would have the sum of J12 + P12 displayed as hh:mm
Anyone know how this can be accomplished? Thank you in advance!