formula for calculating time

[Guest]

Does anyone know how to make excel and hours to a time in a cell? Thanks

 

[Guest]

Does anyone know how to make excel add hours to a time in a cell? Thanks

 

[Frank Kabel]

Hi
not sure what you're trying to do?. Simply enter
10:30
for a time value

--
Regards
Frank Kabel
Frankfurt, Germany

Does anyone know how to make excel and hours to a time in a cell?

Thanks

 

[Fred Smith]

To add, for example, two hours to a time that's in A1, use:

=a1+"2:00"

 

[Guest]

THANKS!! That was the trick. I tried everything I could think of, but I
didnt include the quotes.

I appreciate your time to respond and help me out.

Thanks again.