Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a formula that can assist me with the following?
for example: If I have a person scheduled for 3:43 and the meeting will take 38 minutes, the ending time will be _____? I want to plug in how long the meeting will be and get the new time. -- Kelly C |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you enter both as times, you could use:
=a1+b1 If you enter 3:43 as time and 38 as minutes, you could use: =a1+(b1/24/60) Make sure you format them as times. Kelly wrote: Is there a formula that can assist me with the following? for example: If I have a person scheduled for 3:43 and the meeting will take 38 minutes, the ending time will be _____? I want to plug in how long the meeting will be and get the new time. -- Kelly C -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding X# of minutes to time (HH:MM:SS) | Excel Worksheet Functions | |||
Adding Minutes to Time | Excel Discussion (Misc queries) | |||
Formula for adding minutes to a time cell | Excel Discussion (Misc queries) | |||
Adding Time (hours and minutes) | Excel Programming | |||
Adding minutes to time | Excel Discussion (Misc queries) |