Excel Function

[Matty]

I'm trying to write a formula to calculate time..
Basically, if I have 7:30 AM in a cell what formula will
add 10 hours to it? Will the same formula work for
minutes?

Thanks!

 

[Peo Sjoblom]

=A1+"10:00"

or

=A1+TIME(10,,)

or

A1+10/24

 

[Peo Sjoblom]

Thanks a bunch!

-----Original Message-----
=A1+"10:00"

or

=A1+TIME(10,,)

or

A1+10/24



--

Regards,

Peo Sjoblom





.

 

[Peo Sjoblom]

I thought your name was Matty?

 

[RagDyer]

I thought YOUR name was Peo ! <bg>