Time Calculation Question for Excel

[bjh894]

A1 = 18:20:30
B1 = 130
C1 = ?

I have a start time (A1) and duration in seconds (B1) and need a formula for C1 to display the new time if B1 were added to A1. In this case, the end time would be 18:22:40.

Help, please.

 

[VoG]

Try in C1

=A1+B1/86400

and format as Time.

 

[bjh894]

HOLY MOLY !!!!!!!!!!! It works

I'm new to this forum. In fact, it's the first and only forum I have ever joined. I have been looking on the internet for an answer to this problem for HOURS.

Thank you very much, sir.

Respectfully,

bjh894

 

[AlphaFrog]

This could work as well...

=A1+TIME(0,0,B1)

 

[bjh894]

That too, works. Thanks a million. I appreciate the help.