Calculating Times

  • Thread starter Thread starter Mark 1/2ner
  • Start date Start date
M

Mark 1/2ner

I would like to input a start time (such as 10:00 am) and
a duration (such as 15 minutes) and have Excel calculate
the end time (10:15). Then I would like to use the result
as the start time in the next row. Please help. Is there
a way to get an e-mail notification when someone responds
to this post?
 
No you can't get email notification

A1 = 10:00
B1 = 15
C1 = end time

=A1+B1/1440

format as hh:mm

new row A2

=C1
 
=A1+B1/24/60

This assume you put a number such as 15 in B1

If you put time in B1, just use

=A1+B1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top