I have "time" in cell S1 (example 20:54:58) in cell W1 I have a number of seconds (For instance 55).
In Cell Y1 I want the time in S1 + the seconds in W1 - so in this instance it would be 20:55:53.
Can anyone help
I have "time" in cell S1 (example 20:54:58) in cell W1 I have a number of seconds (For instance 55).
In Cell Y1 I want the time in S1 + the seconds in W1 - so in this instance it would be 20:55:53.
Can anyone help
there maybe a simpler way but try
=TIME(HOUR(S1),MINUTE(S1),SECOND(S1)+W1)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
=S1+(W1/86400)
Try this
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thanks both
your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks