I am trying to get a function that will add time. Example 8:25 + 40 mins= Any suggestions?
B behind the counter person Mar 28, 2008 #1 I am trying to get a function that will add time. Example 8:25 + 40 mins= Any suggestions?
P Pete_UK Mar 28, 2008 #2 The values have to be in the same format, so if you have 8:25:00 in A1 and 40 in B1, you need this in C1: =A1+B1/24/60 and format the cell as [h]:mm to see 9:05. Hope this helps. Pete
The values have to be in the same format, so if you have 8:25:00 in A1 and 40 in B1, you need this in C1: =A1+B1/24/60 and format the cell as [h]:mm to see 9:05. Hope this helps. Pete
