Multiply time by hours

[markman235]

Hi everyone,

I am trying to multiply time by hours. For example 4:00 am x 5 (hours).

The result should be 9:00 am, but i can't find a way to get that.

Any thoughts?

Thanks,

Mark

 

[jeff_miller]

It looks like you want to add hours not multiply?
Put the time in cell A1 and format as "Time 1:30 PM" You would enter 4:00 here
Put the hours you want to add in cell B1 and format as "Custom h:mm" You would enter 5:00 here
In C1 create the formula =A1+B1 and format as "Time 1:30 PM)
result should be 9:00 AM

 

[markman235]

You are going to be my most favorite person for the next 48 hours!!!

Thank you!!!

 

[jeff_miller]

Glad to help