Using Time in formulas

[SPenney]

I want to calculate what seems like an easy formula.

I'm developing a sheet that calculates driving time at a given speed.

Column A is the hours driven (1-96, whole integers)
Column B is the MPH (user defined)
Column C references the arrival time. User would enter their leavin
time into C2. C3 would be C2 + one hour. But I don't seem to be abl
to get the hour to add on. I've tried adding 1, 60, etc. to no avail.

Has anyone had a sucessful solution?

Staci

 

[Frank Kabel]

Hi
I would enter these time values in Excel's time format. So
22:00
for hours driven. Just format the cells with the custom format
[hh]:mm

 

[Niek Otten]

http://www.cpearson.com/excel/datetime.htm#AddingTimes

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[swatsp0p]

This question is easily answered in Exel Help (look up Time).

In cell C3 enter:

=C2+TIME(1,0,0)

this will add 1 hour.

HTH

Bruc