I need to get excel to add a number of hours (ie 103.65) to a time entered (ie 12:31 pm)
W wildecoyote Jun 9, 2009 #1 I need to get excel to add a number of hours (ie 103.65) to a time entered (ie 12:31 pm)
J Jacob Skaria Jun 9, 2009 #2 If you mean to add certain time (say 10 hours and 2 minutes) to a date/time then use =A1+TIME(10,2,0) where A1 holds the date/time If this post helps click Yes
If you mean to add certain time (say 10 hours and 2 minutes) to a date/time then use =A1+TIME(10,2,0) where A1 holds the date/time If this post helps click Yes
D David Biddulph Jun 9, 2009 #3 If your 12:31 PM is in A1, and your 103.65 in A2, then your formula is =A1+A2/24 Format the cell depending on how you want your result displayed. h:mm AM/PM would show 8:10 PM.
If your 12:31 PM is in A1, and your 103.65 in A2, then your formula is =A1+A2/24 Format the cell depending on how you want your result displayed. h:mm AM/PM would show 8:10 PM.
