Using Time in formulas

S

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
 
F

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
 
S

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
 
Top