Money & time formula

[Tracy0715]

Hi there,
I'm not sure if this is even a formula that can be made. I know with certainty it is very far above my knowledge level. So here goes...

I will type a time into cell B25
I would like a formula in cell B26 that divides cell D26 (customer charge) by cell B14 (our hourly rate) gives a quotient of 4.
I then need that 4 hours added to the time I typed in cell B25 so in this example the result in cell B26 should be 4:00PM

 

[myall_blues]

Try

=B25+(D26/B14)/24

 

[Michael M]

Maybe this way

=B25+(D26/B14)*(1/24)

 

[myall_blues]

@Michael M I hate it when that happens

 

[Michael M]

yeah, back at ya !!!

 

[Tracy0715]

Try

=B25+(D26/B14)/24

You are amazing this formula worked!

 

[Tracy0715]

yeah, back at ya !!!

You are amazing as well because this formula worked as well! I don't know what the hell the difference between the two is, but I'm thrilled and beyond happy! Thank you Excel Geniuses!!!!!!!

 

[Michael M]

Glad we could help