I'm stuck.
I have several columns of time listings (e.g. 00:04:27:13). Day-Hour-Min-Sec.
I need to add 54 minutes to each cell (e.g. the above would be 00:05:21:13).
Thanks in advance!
I'm stuck.
I have several columns of time listings (e.g. 00:04:27:13). Day-Hour-Min-Sec.
I need to add 54 minutes to each cell (e.g. the above would be 00:05:21:13).
Thanks in advance!
Last edited by Matt_is_Irish; 02-10-2022 at 03:44 PM.
Use this:
=A3+54/1440
1440 being the number of minutes in a day.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
That keeps spitting back out a value error. I tried doing it with and without a custom format of dd:hh:mm:ss .
Read the yellow banner (top) and post a sample sheet with a few times formatted in the correct manner.
SOLVED:
Had to drop the dd from the dd:hh:mm:ss and then I was able to use the formula provided.
Grand job.
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks