adding time
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
On Mar 28, 7:15*pm, behind the counter person
m wrote:
I am trying to get a function that will add time. *Example 8:25 + 40 mins=
Any suggestions?
|