Scheduling - adding minutes to time
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
|