ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   adding time (https://www.excelbanter.com/excel-worksheet-functions/181717-adding-time.html)

behind the counter person[_2_]

adding time
 
I am trying to get a function that will add time. Example 8:25 + 40 mins=
Any suggestions?

Pete_UK

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?



Mike H

adding time
 
Maybe

08:25 in a1

=A1+TIME(0,40,0)

Mike

"behind the counter person" wrote:

I am trying to get a function that will add time. Example 8:25 + 40 mins=
Any suggestions?



All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com