Need formula to calculate time difference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

markndawoods - 03 Jul 2006 21:22 GMT

I am certain there is a really simple way of doing this and I am just too
stupid to figure it out...

I just want to have Row 1 Column B show a start time I manually enter (say
9:15PM), then be able to enter 10 (ten minutes) in row 2 column A to show a
value of 9:25PM in row 2 column B.

Row 2 Column B has time value (9:20PM)
Row 2 Column A has minutes allowed (20)

In other words, add B2 and A3 and show them as a new time in B3.

Any takers???

Reply to this Message

Marcelo - 03 Jul 2006 21:36 GMT

Hi, if you type just 10 on a2 the formula should be

=b1+time(0;a2;0)

if you type 00:00
is just b1+a2

hth
regards from Brazil
Marcelo

> I am certain there is a really simple way of doing this and I am just too
> stupid to figure it out...
[quoted text clipped - 9 lines]
>
> Any takers???

Reply to this Message

SteveW - 04 Jul 2006 02:58 GMT

Or in maths terms without the
time() function

= b1 + (a2/60/24)

Steve

> Hi, if you type just 10 on a2 the formula should be
>
[quoted text clipped - 23 lines]
>>
>> Any takers???

Signature

Steve (3)

Reply to this Message

David McRitchie - 13 Jul 2006 16:16 GMT

Hi Marcelo,
To help you tie in how the formulas that were supplied as answers
work, you should be aware that time is a fraction of a day. So 6
hours is .25 days, and 20 minutes is =20/(24*60) of a day.

Dates are measured as days past a reference date. You can
read more about Date and Time and their calculations in
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/datetime.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Reply to this Message