How can I calculate duration times given a start time

[Kevin]

I am trying to do some calculations in Excel given a known
start time and a calculated duration time to get a result
that is a time or date and time format? How can I do this?

 

[Peo Sjoblom]

=startdate_time+duration
=A1+B1

where A1 holds the start date/time and B1 the duration

 

[Kevin]

It doesn't work that way with time calculations.

-----Original Message-----
=startdate_time+duration
=A1+B1

where A1 holds the start date/time and B1 the duration

--

Regards,

Peo Sjoblom


this?


.

 

[Peo Sjoblom]

Really, do you care to explain?

 

[Kevin]

Sure,
if you enter a time such as 7:45 AM into a cell formatted
as time and then need to add 9.00 hours, you will not get
4:45 PM. Try it for yourself.

 

[Peo Sjoblom]

Use sum when you calculate it

=SUM(A1,A2)

with 07:45 in A1 and 09:00 in A2

or you can use

="07:45"+"09:00"

 

[Kevin]

If I knew exactly which numbers I could add together, I
could do as you suggested, but the second number in my
case fluctuates and is a calculated number, in minutes
and/or hours with decimal points.

 

[Peo Sjoblom]

You can still do it
if it is a decimal hour value

=A1+A2/24

if A2 holds minutes as integers

=A1+A2/1440

of course if 2 minutes is displayed the same as 2 hours then there is a
problem

 

[Kevin]

Thanks.

-----Original Message-----
You can still do it
if it is a decimal hour value

=A1+A2/24

if A2 holds minutes as integers

=A1+A2/1440

of course if 2 minutes is displayed the same as 2 hours then there is a
problem

--

Regards,

Peo Sjoblom





.