adding time
I am trying to get a function that will add time. Example 8:25 + 40 mins=
Any suggestions? |
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? |
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